| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using cell as worksheet name to return data on that sheet
I have a column that contains the names of all the worksheets in the
workbook. I would like to fill the next column with values from each of those worksheets. Is there a good way OR is there a way I can put a formula in column B that uses column A as the worksheet name? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using cell as worksheet name to return data on that sheet
Try this:
A1 = Sheet 2 =INDIRECT("'"&A1&"'!A1") That will return the value from Sheet 2 cell A1. Biff "Rookie_User" wrote in message ... I have a column that contains the names of all the worksheets in the workbook. I would like to fill the next column with values from each of those worksheets. Is there a good way OR is there a way I can put a formula in column B that uses column A as the worksheet name? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using cell as worksheet name to return data on that sheet
Look in Help for the INDIRECT() function
-- Kind regards, Niek Otten Microsoft MVP - Excel "Rookie_User" wrote in message ... |I have a column that contains the names of all the worksheets in the | workbook. I would like to fill the next column with values from each of | those worksheets. Is there a good way OR is there a way I can put a formula | in column B that uses column A as the worksheet name? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using cell as worksheet name to return data on that sheet
This worked perfect and saved me a ton of time, thank you so much for your
time and efforts, and your creativity. "T. Valko" wrote: Try this: A1 = Sheet 2 =INDIRECT("'"&A1&"'!A1") That will return the value from Sheet 2 cell A1. Biff "Rookie_User" wrote in message ... I have a column that contains the names of all the worksheets in the workbook. I would like to fill the next column with values from each of those worksheets. Is there a good way OR is there a way I can put a formula in column B that uses column A as the worksheet name? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using cell as worksheet name to return data on that sheet
You're welcome. Thanks for the feedback!
Biff "Rookie_User" wrote in message ... This worked perfect and saved me a ton of time, thank you so much for your time and efforts, and your creativity. "T. Valko" wrote: Try this: A1 = Sheet 2 =INDIRECT("'"&A1&"'!A1") That will return the value from Sheet 2 cell A1. Biff "Rookie_User" wrote in message ... I have a column that contains the names of all the worksheets in the workbook. I would like to fill the next column with values from each of those worksheets. Is there a good way OR is there a way I can put a formula in column B that uses column A as the worksheet name? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reconciliation of Data With Two Conditions | Excel Worksheet Functions | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| macro | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
