| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
reference work sheet name by using a formula
I have multiple sheets. Instead of using the harcode sheet name and the
reference cell in that sheet, is there a way to refer to the worksheet name using a label. I want to copy a value from sheet named "XYZ" cell "F5" to my current Sheet1 cell "A2". Usual way is cell "A2" in Sheet1 would contain the ='XYZ'!$F$5. Can I have a cell "A1" in Sheet1 with the value XYZ. Then my formula would refer to that cell "A1". example =A1!F5 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
reference work sheet name by using a formula
=INDIRECT(A1&"!F5")
"worksheet reference by label" wrote: I have multiple sheets. Instead of using the harcode sheet name and the reference cell in that sheet, is there a way to refer to the worksheet name using a label. I want to copy a value from sheet named "XYZ" cell "F5" to my current Sheet1 cell "A2". Usual way is cell "A2" in Sheet1 would contain the ='XYZ'!$F$5. Can I have a cell "A1" in Sheet1 with the value XYZ. Then my formula would refer to that cell "A1". example =A1!F5 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
reference work sheet name by using a formula
If A1 contains XYZ you can use in A2:
=INDIRECT(A1&"!F5) to get the value from XYZ!F5 Tyro "worksheet reference by label" <worksheet reference by wrote in message ... I have multiple sheets. Instead of using the harcode sheet name and the reference cell in that sheet, is there a way to refer to the worksheet name using a label. I want to copy a value from sheet named "XYZ" cell "F5" to my current Sheet1 cell "A2". Usual way is cell "A2" in Sheet1 would contain the ='XYZ'!$F$5. Can I have a cell "A1" in Sheet1 with the value XYZ. Then my formula would refer to that cell "A1". example =A1!F5 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
reference work sheet name by using a formula
Correction:
=INDIRECT(A1&"!F5") to get the value from XYZ!F5 "Tyro" wrote in message .. . If A1 contains XYZ you can use in A2: =INDIRECT(A1&"!F5) to get the value from XYZ!F5 Tyro "worksheet reference by label" <worksheet reference by wrote in message ... I have multiple sheets. Instead of using the harcode sheet name and the reference cell in that sheet, is there a way to refer to the worksheet name using a label. I want to copy a value from sheet named "XYZ" cell "F5" to my current Sheet1 cell "A2". Usual way is cell "A2" in Sheet1 would contain the ='XYZ'!$F$5. Can I have a cell "A1" in Sheet1 with the value XYZ. Then my formula would refer to that cell "A1". example =A1!F5 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vb code for renaming a work sheet with a cell reference | Excel Discussion (Misc queries) | |||
| reference to other sheet doesnt work | Excel Worksheet Functions | |||
| Change the work sheet name in a formula by using cell reference | Excel Worksheet Functions | |||
| Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
| Need Vlookup to work with formula in reference cell | Excel Discussion (Misc queries) | |||
Linear Mode
