S
Sales26
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.
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.