Prev: How do I provide new sample spreadsheets to office online
Next: Formula shows in cell instead of results (text reference)
From: kim on 5 Apr 2010 17:47
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. ?
From: Don Guillett on 5 Apr 2010 18:01
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
dguillett(a)gmail.com
"kim" <kim(a)discussions.microsoft.com> wrote in message
news:201EB140-F371-43B0-8921-29FD776E3637(a)microsoft.com...
>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. ?

From: Gord Dibben on 6 Apr 2010 13:05
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 <kim(a)discussions.microsoft.com>
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. ?

 | 
Pages: 1
Prev: How do I provide new sample spreadsheets to office online
Next: Formula shows in cell instead of results (text reference)