Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding cell contents in different worksheets | Excel Discussion (Misc queries) | |||
Referencing cell in another sheet yields null? | Excel Worksheet Functions | |||
Absoulte referencing between worksheets | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions |