Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning contents of a cell in another sheet in same workbook
I am using multiple sheets. I have a defined name set up in each sheet.
For example I am in Sheet 1. In sheet 1, col a I have a list of the other Sheets, like Sheet 2, Sheet 3 etc etc. In Col 2 of Sheet 1 I want to return the value in B2 of Sheet 2 using the sheet 2 name that I have listed in Col a of sheet 1 Does this make sense -- Annette |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning contents of a cell in another sheet in same workbook
Try this in B1 (assuming your names start in A1):
=INDIRECT("'"&A1&"'!B$2") and copy this down. Note the use of apostrophes in case you have spaces in your names - the items after the first bracket are <quotes<apostrophe<quotes and after the second & it is <quotes<apostrophe. I assume you always want data from cell B2 of the other sheets - hence the use of $ before the 2 so it does not change to B3, B4 etc when you copy it down. Hope this helps. Pete On Mar 14, 3:50 pm, Annette wrote: I am using multiple sheets. I have a defined name set up in each sheet. For example I am in Sheet 1. In sheet 1, col a I have a list of the other Sheets, like Sheet 2, Sheet 3 etc etc. In Col 2 of Sheet 1 I want to return the value in B2 of Sheet 2 using the sheet 2 name that I have listed in Col a of sheet 1 Does this make sense -- Annette |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning Cell Contents of One Cell Based On Another Cell | Excel Worksheet Functions | |||
Searching in another workbook for a string and returning with the contents of the cell next to it. | Excel Worksheet Functions | |||
Table of Contents Sheet in Workbook | Links and Linking in Excel | |||
Returning Cell Value if someone deletes the contents of a cell | Excel Worksheet Functions | |||
Returning contents of a cell | Excel Worksheet Functions |