General discussion


Adding cells from multiple worksheets

By cpapachristou ·
New Posts
Reply To
This Thread E-mail It

Print It Next

mistos (IS/IT--Manageme)
Mar 8, 2002I have multiple worksheets that are all identical except for data and the
worksheet name. I also have a worksheet called Tally. I am looking to
take the same cell from every worksheet and copy the data in that cell
to the corresponding row in the Tally sheet. The Tally sheet consists of
the names of each worksheet. Currently I am going to each row in the
tally sheet and typing ='sheet1'!F1 for each row item in the tally sheet
corresponding to the named worksheet. Is there any way I can do the first item in the tally and then drag down the the cell, having it take cell F1 from each worksheet and corresponding its similarly named row in the tally. The rows in the tally sheet are in the same order as the worksheets.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Adding cells from multiple worksheets

by DKlippert In reply to Adding cells from multipl ...

Exactly! You'll have to change the sheet name as you go from sheet to sheet. You can also select the sheets and create "3-D" formulas such as
=Sum(Sheet1:Sheet3!C33). That formula will sum up all the C33 values on all of the Worksheets from Sheet1to Sheet3.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums