Excel help needed

[Rosee]

I have an Excel file with multiple sheets of data. I would like to add a summary sheet which would show subtotal from data sheets and then SUM them all together. Whenever the subtotal numbers get changed, the SUM on the summary sheet will get changed as well. How could I do this?

How to have subtotal numbers showing on the summary sheet? Do I have to use Macro or Function? Please advise. Thanks.

 

[SkipVought]

Rosee,

Have you tried a formula to sum the subtotals from each sheet?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[Rosee]

Yes. But I like to have total from each sheet showing on summary sheet automatically. Do you know how?

 

[SkipVought]

What do you mean by "automatically"???

What formulas or totals happen in Excel "automatically"?

You have to actually DO something to perform something that looks "automatic"

Is it that you want to, for instance, sum the subtotal from A1 on sheets 2 thru 10 on sheet 1? Please be specific!

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[KenWright]

What are your sheet names like?

Sheet1 Sheet2 Sheet3 perhaps, or maybe some kind of numeric progression?

How many sheets are we talking?

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[Rosee]

I have 5 sheets of data so far. This is what I like to do:

sheet1: total A1=$4500
sheet2: total A2=$6000
Sheet3: total A3=$3490
Sheet4: total A4=$1285
Sheet5: total A5=$5500

Summary Sheet:
A1=$4500
A2=$6000
A3=$3490
A4=$1285
A5=$5500
All total=(A1+A2+A3+A4+A5)

The value of A1 to A5 changed daily on each sheet, I like value of A1 to A5 on summary sheet reflect changes at the same time. Do I need to set Variables?

 

[SkipVought]

[tt]
Summary Sheet:
A1=sheet1!A1
A2=sheet2!A2
A3=Sheet!A3
A4=Sheet4!A4
A5=Sheet5!A5
A6=SUM(A1:A5)
[/tt]

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[SkipVought]

Actually you can enter this in rows 1 to 5
[tt]
=INDIRECT("sheet"&ROW()&"!a"&ROW())
[/tt]

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[Rosee]

Thanks, Skip. It worked.