|
|
Browse by Tags
- 2000
- 2002
- 2003
- 2007
- access
- another
- array
- auto
- box
- C#
- calculate
- cell
- cells
- change
- chart
- color
- column
- columns
- convert
- copy
- create
- crystal
- csv
- data
- date
- delete
- display
- document
- down
- drop
- dts
- error
- Excel 2007
- export
- extract
- file
- files
- find
- form
- format
- formula
- formulas
- from
- function
- graph
- how
- hyperlink
- import
- insert
- list
- lotus
- macro
- macros
- Microsoft
- MS
- multiple
- notes
- number
- Numbers
- Office
- open
- oracle
- outlook
- paste
- pivot
- powerpoint
- query
- range
- read
- reference
- remove
- report
- row
- rows
- save
- Script
- server
- sharepoint
- sheet
- slow
- sort
- spreadsheet
- sql
- sum
- table
- text
- time
- userform
- value
- VB
- vba
- Visual Basic
- vlookup
- VSTO
- word
- workbook
- worksheet
-
Why won't the end key work in Excel?
I have a column with information in some of the cells, and I want to stop at each of those cells in my macro. Using the "End" key, I should be able to make that stop at the next cell that contains data, but in the column I want to use, it doesn't stop. The column is the result of a simple... -
Copy and paste Data
Hi, I need Experts help to create a VBA/macro. Copy data from column_B (List sheet) and paste at column_D if the value starts “F00”,”#” ,and “F01”. I have manually copied few data sample for Experts perusal. Hope Experts can help me to create this feature. -
Macro/VBA for Consolidate data
Hi Experts, I need Experts help. Copy data from Column D,E,K and L (Database) to Column E,F,G and H (List) sheet if the data from Column_D (List) matched with data at column_C(List). I have manually copied few sample data for Experts to get a better view. Hope Experts can help me to create this feature... -
Create Excel Chart in VBScript
Could someone provide me a snippet of code that would, in VBScript, create the Excel object, put in some data, and then automatically show some sort of chart? Never worked with the Excel object before in VBScript. I've got data from a database and just need to port it into Excel and build a chart... -
Copy value based on cell
Hi, I have two worksheets. In worksheet two i have the following columns Country, currency, language, etc, etc, etc In sheet 1 i have a pick list for country and also two additional country columns. If they select USA, i would like the two columns in worksheet 1 for country, currency, language to automatically... -
Excel
Hi, I have a date in the following format in cell A! (in excel) Thursday June 10 12:23:43 2010 I need to add 12 hours, 30 minutes to this. So I tried the following formula. =A1 + time(12,30,0) it's not working. Can you please suggest how to deal with this situation? Thanks, Rohit. -
VBScript and reading from MS Excel file
I have an excel file in the following format: ColumnName _____________ TEST TEST05 11TEST02 123455 98666 VALUE09 I need to use VBScript to read the data from the file into an array. What's the best way to do that? Another problem is that the file might also be in CSV format or TXT format. How to... -
Excel 2003 - Convert XLS to CSV automated
Hi: I have been reading the forums here and have not been able to figure out how to convert and XLS file to CSV format. The file is located in: C:\Automated CFP Reporting\mail The file name is not static - well actually the only thing static is the IRR at the front: IRR*.xls I would like to take this... -
Formula on Pivot Table subtotal only
I have the attached pivot table and I would like to calculate column e - column f just on the total rows. How can I do this. thank you in advance for your expert advice. :) -
Can I join on NULL values in Crystal 2008?
I have two sets of data which will use 4 joins. In same cases the value of the join field is NULL in both sets of data. Is there anyway to faciliate this link? Currently I've done a left outer join from my larger set of data but it's missing the those values with a NULL. One of my data tables...