Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable Worksheet Name in Formula
Good morning --
I have a workbook storing similar data on multiple worksheets. I have a 'Report' page, from which I'd like to abstract the right person's data onto a jpeg form and print it out. I'd like to be able to put the person's name in a cell at the top of the page, and have formulas extract the data from the associated worksheet. So, if I have worksheets labeled 'Smith', 'Jones', and 'Wesson', on the 'Report' sheet I'd like to put 'Smith' in, say, cell B1 and have a formula pick up that value and go to the 'Smith' page to pull in the info from, say, cell C50. Is that possible without VBA code? TIA |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable Worksheet Name in Formula
=INDIRECT(B1 & "!C50")
-- Gary''s Student - gsnu200773 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable Worksheet Name in Formula
Gary's Student --
Grasshopper, you are a student no longer! Many thanks. Saved me DAYS of work. (If you're too young for the 'grasshopper' reference -- congrats, and I can let you know where it's from...) peter "Gary''s Student" wrote: =INDIRECT(B1 & "!C50") -- Gary''s Student - gsnu200773 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable Worksheet Name in Formula
Try this:
=IF(B1="","",INDIRECT("'"&B1&"'!C50")) -- Biff Microsoft Excel MVP "pdberger" wrote in message ... Good morning -- I have a workbook storing similar data on multiple worksheets. I have a 'Report' page, from which I'd like to abstract the right person's data onto a jpeg form and print it out. I'd like to be able to put the person's name in a cell at the top of the page, and have formulas extract the data from the associated worksheet. So, if I have worksheets labeled 'Smith', 'Jones', and 'Wesson', on the 'Report' sheet I'd like to put 'Smith' in, say, cell B1 and have a formula pick up that value and go to the 'Smith' page to pull in the info from, say, cell C50. Is that possible without VBA code? TIA |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable Worksheet Name in Formula
He's selling Yellow Book ads now...lol
Regards, Howard "pdberger" wrote in message ... Good morning -- I have a workbook storing similar data on multiple worksheets. I have a 'Report' page, from which I'd like to abstract the right person's data onto a jpeg form and print it out. I'd like to be able to put the person's name in a cell at the top of the page, and have formulas extract the data from the associated worksheet. So, if I have worksheets labeled 'Smith', 'Jones', and 'Wesson', on the 'Report' sheet I'd like to put 'Smith' in, say, cell B1 and have a formula pick up that value and go to the 'Smith' page to pull in the info from, say, cell C50. Is that possible without VBA code? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet referenced in same file as variable in formula? | Excel Discussion (Misc queries) | |||
Excel Named Formula Weakly Interacts with a Variable Range on the Worksheet - Re-Visit | Excel Discussion (Misc queries) | |||
How do I use a worksheet name as an input variable to a formula? | Excel Discussion (Misc queries) | |||
Variable worksheet name (tab) linked to cell in same worksheet | Excel Worksheet Functions | |||
Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) |