Referencing cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
hi

you may want to look at this site for summary sheets

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

regards
Brian
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
Click to expand...
[quoted text clipped - 15 lines]
Click to expand...
 
Back
Top