referencing same cell in several worksheets
 

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?
--
thanks!!

referencing same cell in several worksheets
 

You can create the links fast with this macro
http://www.rondebruin.nl/summary.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"coriolis" wrote in message ...
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?
--
thanks!!

referencing same cell in several worksheets
 

- 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


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=543891