Referencing cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cate - 26 Apr 2006 16:42 GMT

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

Reply to this Message

Gord Dibben - 26 Apr 2006 18:04 GMT

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 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
[quoted text clipped - 4 lines]
>
>Thanks

Reply to this Message

cate - 26 Apr 2006 19:41 GMT

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

Reply to this Message

brian thompson3001 - 26 Apr 2006 20:34 GMT

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
[quoted text clipped - 11 lines]
>> >
>> >Thanks

Signature

bnt

Reply to this Message