Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using worksheet names as references
I am not sure I can do this or not or if there is any easier way to do
this... any help appreciated. I have several worksheets in a workbook. To keep it simple, the worksheet names are A, B, C, D, etc. I am building a large summary table and I want to keep my formulas as simple as possible. I have entered the names of theworksheets (A, B, C, etc.) into cells A1, A2, A3, and A4, etc. I'd like to have formulas that more or less say "go to the worksheet that is referenced in cell A1, or A2, etc. Is that possible? Thanks bmac |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using worksheet names as references
Hi,
Is this what you mean =INDIRECT("'"&A1&"'!D10") A valid worksheet name in a1 would make this formula refer to d1 on that worksheet. Mike "bmac" wrote: I am not sure I can do this or not or if there is any easier way to do this... any help appreciated. I have several worksheets in a workbook. To keep it simple, the worksheet names are A, B, C, D, etc. I am building a large summary table and I want to keep my formulas as simple as possible. I have entered the names of theworksheets (A, B, C, etc.) into cells A1, A2, A3, and A4, etc. I'd like to have formulas that more or less say "go to the worksheet that is referenced in cell A1, or A2, etc. Is that possible? Thanks bmac |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using worksheet names as references
bmac wrote:
I am not sure I can do this or not or if there is any easier way to do this... any help appreciated. I have several worksheets in a workbook. To keep it simple, the worksheet names are A, B, C, D, etc. I am building a large summary table and I want to keep my formulas as simple as possible. I have entered the names of theworksheets (A, B, C, etc.) into cells A1, A2, A3, and A4, etc. I'd like to have formulas that more or less say "go to the worksheet that is referenced in cell A1, or A2, etc. Is that possible? Thanks bmac If you want cell Z1 in the current worksheet to display the contents of cell G12 in the worksheet named C, this would be the formula: ='C'!G12 You can see this by placing an equal sign in Z1 and then clicking on cell G12 of worksheet C. If you want the contents of cell A3 on the current worksheet to determine which worksheet to pull the value of cell G12 from, then you would use the INDIRECT formula as follows: =INDIRECT("'"&A3&"'!G12") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using worksheet names as references
Hello
Install the ASAP UTILITIES, choose <Sheets <Create an index page with all sheets (clickable) As simple as that!!! Success -- met vriendelijke groetjes "bmac" schreef in bericht ... I am not sure I can do this or not or if there is any easier way to do this... any help appreciated. I have several worksheets in a workbook. To keep it simple, the worksheet names are A, B, C, D, etc. I am building a large summary table and I want to keep my formulas as simple as possible. I have entered the names of theworksheets (A, B, C, etc.) into cells A1, A2, A3, and A4, etc. I'd like to have formulas that more or less say "go to the worksheet that is referenced in cell A1, or A2, etc. Is that possible? Thanks bmac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find references to cell names | Excel Discussion (Misc queries) | |||
range names to cell references | Excel Worksheet Functions | |||
Apply names to relative references | Excel Worksheet Functions | |||
Cell References/Names | Excel Discussion (Misc queries) | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) |