Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto update to multiple worksheets
I have created an Excel workbook which contains multiple worksheets of
financial data. what I need to know is How do I get the financial data totals from work sheet 1 to auto-populate into worksheet # 2, from worksheet #2 to #3, etc. ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto update to multiple worksheets
Maybe a redesign?
If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "kim" wrote in message ... I have created an Excel workbook which contains multiple worksheets of financial data. what I need to know is How do I get the financial data totals from work sheet 1 to auto-populate into worksheet # 2, from worksheet #2 to #3, etc. ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto update to multiple worksheets
Copy/paste this UDF to a general module in your workbook.
Function PrevSheet(rg As Range) n = Application.Caller.Parent.Index If n = 1 Then PrevSheet = CVErr(xlErrRef) ElseIf TypeName(Sheets(n - 1)) = "Chart" Then PrevSheet = CVErr(xlErrNA) Else PrevSheet = Sheets(n - 1).Range(rg.Address).Value End If End Function Example of usage................... Say you have 12 sheets, sheet1 through sheet12...........sheet names don't matter. In sheet1 you have a formula in A10 =SUM(A1:A9) Select second sheet and SHIFT + Click last sheet In active sheet A10 enter =SUM(PrevSheet(A10),A1:A9) Ungroup the sheets. Each A10 will have the sum of the previous sheet's A10 plus the sum of the current sheet's A1:A9 Gord Dibben MS Excel MVP On Mon, 5 Apr 2010 14:47:46 -0700, kim wrote: I have created an Excel workbook which contains multiple worksheets of financial data. what I need to know is How do I get the financial data totals from work sheet 1 to auto-populate into worksheet # 2, from worksheet #2 to #3, etc. ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Update worksheet references as new worksheets are added | Excel Worksheet Functions | |||
Auto update worksheets | Excel Worksheet Functions | |||
Auto Update the formula values without opening the link worksheets | Excel Worksheet Functions | |||
How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
Sharing data between worksheets (auto-update) | Excel Discussion (Misc queries) |