| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic sheet reference
How do I create a dynamic reference to a sheet throught a specific cell
location? For example: cell ref!A5 where cell ref is the text contents of a specific cell like B8. -- steve |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dynamic sheet reference
See the INDIRECT function in Excel Help.
If B8: Sheet 3 Then this formula returns the value of cell A5 on the 'Sheet 3' worksheet: =INDIRECT("'"&B8&"'!A5") Note: the quote marks can be confusing.... The left set is: Dbl-quote.....Single-quote...Dbl-quote The right set is: Dbl-quote...Single-quote...!A5...Dbl-quote When a sheet name includes spaces, references to it must be enclosed in single-quotes. Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "steve" wrote in message ... How do I create a dynamic reference to a sheet throught a specific cell location? For example: cell ref!A5 where cell ref is the text contents of a specific cell like B8. -- steve |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dynamic sheet reference
This is perfect. Thanks
-- steve "Ron Coderre" wrote: See the INDIRECT function in Excel Help. If B8: Sheet 3 Then this formula returns the value of cell A5 on the 'Sheet 3' worksheet: =INDIRECT("'"&B8&"'!A5") Note: the quote marks can be confusing.... The left set is: Dbl-quote.....Single-quote...Dbl-quote The right set is: Dbl-quote...Single-quote...!A5...Dbl-quote When a sheet name includes spaces, references to it must be enclosed in single-quotes. Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "steve" wrote in message ... How do I create a dynamic reference to a sheet throught a specific cell location? For example: cell ref!A5 where cell ref is the text contents of a specific cell like B8. -- steve |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dynamic sheet reference
Glad to help!
-------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "steve" wrote in message ... This is perfect. Thanks -- steve "Ron Coderre" wrote: See the INDIRECT function in Excel Help. If B8: Sheet 3 Then this formula returns the value of cell A5 on the 'Sheet 3' worksheet: =INDIRECT("'"&B8&"'!A5") Note: the quote marks can be confusing.... The left set is: Dbl-quote.....Single-quote...Dbl-quote The right set is: Dbl-quote...Single-quote...!A5...Dbl-quote When a sheet name includes spaces, references to it must be enclosed in single-quotes. Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "steve" wrote in message ... How do I create a dynamic reference to a sheet throught a specific cell location? For example: cell ref!A5 where cell ref is the text contents of a specific cell like B8. -- steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic reference to another tab name | Excel Worksheet Functions | |||
| Dynamic name reference in SUMPRODUCT | Excel Worksheet Functions | |||
| Dynamic reference to another sheet? | Excel Worksheet Functions | |||
| Dynamic reference to a sheet | Excel Worksheet Functions | |||
| Dynamic reference to sheet name | Excel Worksheet Functions | |||
Linear Mode
