Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing data in multiple spreadsheets with the first being the m | Excel Worksheet Functions | |||
get data from multiple spreadsheets into another | Excel Discussion (Misc queries) | |||
suggestions for designing multiple workbook models | Excel Discussion (Misc queries) | |||
synchronizing data on multiple spreadsheets | Excel Worksheet Functions | |||
Importing from access database into multiple spreadsheets | Excel Discussion (Misc queries) |