software

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 quot;startquot; and quot;endquot; 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!!

You can create the links fast with this macro
www.rondebruin.nl/summary.htm--
Regards Ron de Bruin
www.rondebruin.nlquot;coriolisquot; gt; wrote in message ...
gt; Hi!
gt; Is there a function i can use to automatically generate a list of the
gt; contents of a single cell from other worksheets? I have a file with template
gt; project worksheets, and i have created quot;startquot; and quot;endquot; bookend sheets that
gt; i can drag and click so that a roll-up summary is automatically created
gt; summing certain cells on sheets that are included between the bookends, but i
gt; also want to have the roll-up summary sheet list the name of each individual
gt; project (ie create an automatic list of cell D6 from each worksheet that is
gt; between my bookends). Is this possible?
gt; --
gt; thanks!!

- In the appropriate cell, type:
=Sheet1!D6
Just replace quot;Sheet1quot; 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 quot;=quot;, 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: www.excelforum.com/member.php...oamp;userid=32097
View this thread: www.excelforum.com/showthread...hreadid=543891