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! |
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! |
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! |
All times are GMT +1. The time now is 01:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com