Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Variable Worksheets
Here is my present pickle with Excel.
I have been asked to create a worksheet that will be emailed in once a week. A Master worksheet will read the data off the individual worksheets and display all the data on one page. Further, the Master worksheet will need to be able to compare this data with the data from the prior week. All this needs to be done with little to no actual work done by the person looking over the Master worksheet. The individual sheets will look much like this: John Doe July 5, 2004 July Aug Sept $300 $250 $123 $1000 $750 $300 The master sheet will look much like this: July August Sept 6/28 7/5 6/28 7/5 6/28 7/5 John Doe $200 $300 $100 $250 $0 $123 Jane Plain $200 $345 $400 $200 $10 $0 John Doe $900 $1000 $500 $750 $40 $300 Jane Plain Any ideas or insights that might help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference other worksheets via variable names | Excel Worksheet Functions | |||
Searching in 'variable' worksheets | Excel Discussion (Misc queries) | |||
variable across all worksheets? | Excel Worksheet Functions | |||
Referencing Variable Name Worksheets | New Users to Excel | |||
Using variable to call worksheets | Excel Programming |