Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!! |
#2
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy link from next worksheet | Excel Worksheet Functions | |||
LINK ONE ROW BASED ON CONTENTS OF A COLUMN WITHIN THE ROW (DATE) | Excel Worksheet Functions | |||
How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions | |||
Link in worksheet | Excel Discussion (Misc queries) | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel |