Link based on worksheet name?
I have a workbook that contains a summary worksheet as well as the detail
sheets broken down by topic. The detail sheets all contain a value that has consistent placement that I would like to reference in my summary sheet. For example, summary sheet contains: Toys, Books, Clothing in cells A2, A3 and A4 respectively. I want to include the value from cell B4 in the detail sheets which are named Toys, Books, and Clothing. The summary sheet is fairly extensive so I do not want to have to select each sheet indenpendently. Is there anything that I can (e.g. a forumula or a feature) to make this process a little easier? Thanks!! |
Try
=INDIRECT($A2&"!B4") If you want, you can put the "B4" (and all your other detail sheet target cell addresses) into appropriate cells on your summary sheet & then use something like =INDIRECT($A2&"!"&B$1) where B1 on the summary sheet contains the text "B4" This allows you to copy the INDIRECT formula to other cells and have it adjust to whatever target cell address you have entered in the first row of the summary sheet "tpmax" wrote in message ... I have a workbook that contains a summary worksheet as well as the detail sheets broken down by topic. The detail sheets all contain a value that has consistent placement that I would like to reference in my summary sheet. For example, summary sheet contains: Toys, Books, Clothing in cells A2, A3 and A4 respectively. I want to include the value from cell B4 in the detail sheets which are named Toys, Books, and Clothing. The summary sheet is fairly extensive so I do not want to have to select each sheet indenpendently. Is there anything that I can (e.g. a forumula or a feature) to make this process a little easier? Thanks!! |
All times are GMT +1. The time now is 03:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com