Designing Multiple Spreadsheets with scaled data access.
 

Richard,
I'm not sure I can solve the problem to all of your criteia, but consider
this is a start
Assuming that your sheets are called Sheet1, Sheet2, Sheet3, ....

A normal excel refernce equation to bring data from Sheet 3 to Sheet4 would
be in a cell (or cell array):

=Sheet3!E2

Another way to do this is to use INDIRECT as follows:

=INDIRECT($A$1&"!E2")

and the value of Cell A1 is the text string "Sheet3"

This would allow you to create multiple sheets from the same template sheet,
and now, by setting Cell A1 in each sheet to its predecessor (simple in VBA)
you would have an excellent set of linked sheets.

Another way might be to have a central (hidden) database sheet that pulls
from each daily sheet, does the totals, and can provide them to the next
daily sheet as a previous subtotal.

Is this a start?

Alex@JPCS


"Richard Billingsley" wrote in message
...
I know it is possible to select several spreadsheets and create a common
page design that affects all pages the same way.

But is possible to do this and have each page get its data from a relative
location?

Here's what I want to do:

1. Create one workbook with the number of worksheets equal to the number
of
days in the month.
2. There are three sets of three column in each of the worksheets: Today,
Month To Date, Year To Date.
3. Each set of three columns do the same thing: # of Sales, Total $,
Average
$

This is what I need to really know if it is possible:
4. In the Month To Date and Year To Date columns get the total from the
previous days total of the previous worksheet and add the corresponding
numbers for the "# of Sales" and "Total $" current day.

The challenge: do this by selecting all the worksheets for the month and
designing only one worksheet. The end result is that the MTD and YTD
columns use relative coding to know they only get info from the previous
days data. Not the worksheet that was used to design the entire workbook.

Can this be done? If so, How?

Thanks,


--
Richard Billingsley

Note: To reply via email replace "deadend.com" with "vbig.com" before
sending.