Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a summary worksheet that references data in other sheets?
Suppose my workbook has 10 worksheets in it. Each one similarly formatted from a template. I want to create a summary page that references all other worksheets. For example: 10 worksheets that all have a Production Date in cell B15. I want to create a summary page, that directly reflects the project name and the production date. I can't seem to hit upon the correct formula or function for the summary page to grab the date in cell B15 of the other worksheets. Thanks for any help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a summary worksheet that references data in other sheets?
Hi GB
=Sheet1!B15 =Sheet2!B15 ................. ............. This macro create the links for you http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "GB" wrote in message news:1140463358.502727@sj-nntpcache-5... Suppose my workbook has 10 worksheets in it. Each one similarly formatted from a template. I want to create a summary page that references all other worksheets. For example: 10 worksheets that all have a Production Date in cell B15. I want to create a summary page, that directly reflects the project name and the production date. I can't seem to hit upon the correct formula or function for the summary page to grab the date in cell B15 of the other worksheets. Thanks for any help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a summary worksheet that references data in other sheets?
Thanks Ron!
I tried this but it didn't work, then I tried renaming my sheet and it worked. Apparently, it doesn't like the fact that my Sheet2 name was "686-Project1(3)". I think it was trying to do the math on the name of the sheet because it kept prompting me for file names to update. Once I renamed it to "Project1" it worked. Now I have to go rename all of my worksheets! :) "Ron de Bruin" wrote in message ... Hi GB =Sheet1!B15 =Sheet2!B15 ................ ............ This macro create the links for you http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "GB" wrote in message news:1140463358.502727@sj-nntpcache-5... Suppose my workbook has 10 worksheets in it. Each one similarly formatted from a template. I want to create a summary page that references all other worksheets. For example: 10 worksheets that all have a Production Date in cell B15. I want to create a summary page, that directly reflects the project name and the production date. I can't seem to hit upon the correct formula or function for the summary page to grab the date in cell B15 of the other worksheets. Thanks for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data | Excel Worksheet Functions | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
Summary of data from 20 sheets | Excel Discussion (Misc queries) | |||
Workbook Summary Data from Sheets | Excel Worksheet Functions |