referencing same cell in several worksheets

C

coriolis

Hi!
Is there a function i can use to automatically generate a list of the
contents of a single cell from other worksheets? I have a file with template
project worksheets, and i have created "start" and "end" bookend sheets that
i can drag and click so that a roll-up summary is automatically created
summing certain cells on sheets that are included between the bookends, but i
also want to have the roll-up summary sheet list the name of each individual
project (ie create an automatic list of cell D6 from each worksheet that is
between my bookends). Is this possible?
 
P

protonLeah

- In the appropriate cell, type:
=Sheet1!D6
Just replace "Sheet1" with the names of your sheets, etc.

- Alternatively, on the sheet where you desire the list of project
name, click in a cell, say D6, type "=", then go to the sheet with
the project name and click the cell holding the name, and press TAB
to accept.

___________________________
Ben
 
Top