I have an excel file with many spreadsheets (tabs). I need to take certain
totals from each spreadsheet and put them into a summary spreadsheet. My
question is: Is there a quicker way to do this than typing = and then going
to the cell on the appropriate spreadsheet and hitting enter.

I hope this makes sense.

Thanks

cate

If the total cells are same cell on each sheet you can use the 3D formula

=Sheet1:Sheet34!D16

If not D16 on each sheet, the method you describe is the only way other than
typing the Sheet and cell references.


Gord Dibben MS Excel MVP

On Wed, 26 Apr 2006 08:42:01 -0700, cate wrote:

I have an excel file with many spreadsheets (tabs). I need to take certain
totals from each spreadsheet and put them into a summary spreadsheet. My
question is: Is there a quicker way to do this than typing = and then going
to the cell on the appropriate spreadsheet and hitting enter.

I hope this makes sense.

Thanks

I don't think I asked the question clearly enough. Say I have 10 subsidiary
worksheets. On each subsidiary worksheet I need to reference cell D16 and
put it into 10 SEPARATE cells in the consolidated worksheet each cell
representing 1 subsidiary. Then I will write a formula in the consolidated
worksheet to sum them up. Does this make the answer any different. I
thought I read somewhere that I may be able to do a vlookup or ifsum to help
do this, but I'm not sure.

Thank you, Cate


"Gord Dibben" wrote:

cate

If the total cells are same cell on each sheet you can use the 3D formula

=Sheet1:Sheet34!D16

If not D16 on each sheet, the method you describe is the only way other than
typing the Sheet and cell references.


Gord Dibben MS Excel MVP

On Wed, 26 Apr 2006 08:42:01 -0700, cate wrote:

I have an excel file with many spreadsheets (tabs). I need to take certain
totals from each spreadsheet and put them into a summary spreadsheet. My
question is: Is there a quicker way to do this than typing = and then going
to the cell on the appropriate spreadsheet and hitting enter.

I hope this makes sense.

Thanks

hi

you may want to look at this site for summary sheets

http://www.rondebruin.nl/copy2.htm

regards
Brian

cate wrote:
I don't think I asked the question clearly enough. Say I have 10 subsidiary
worksheets. On each subsidiary worksheet I need to reference cell D16 and
put it into 10 SEPARATE cells in the consolidated worksheet each cell
representing 1 subsidiary. Then I will write a formula in the consolidated
worksheet to sum them up. Does this make the answer any different. I
thought I read somewhere that I may be able to do a vlookup or ifsum to help
do this, but I'm not sure.

Thank you, Cate

cate

[quoted text clipped - 15 lines]

Thanks

--
bnt

Message posted via http://www.officekb.com