Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing data in multiple spreadsheets with the first being the m LindaR Excel Worksheet Functions 5 June 18th 09 07:45 PM
get data from multiple spreadsheets into another cgy Excel Discussion (Misc queries) 2 September 9th 08 03:57 PM
suggestions for designing multiple workbook models nickname Excel Discussion (Misc queries) 0 October 4th 07 05:39 PM
synchronizing data on multiple spreadsheets Ha-Lee Excel Worksheet Functions 0 January 31st 07 04:33 PM
Importing from access database into multiple spreadsheets Sandy Excel Discussion (Misc queries) 1 September 8th 05 03:55 AM


All times are GMT +1. The time now is 02:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"