| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2')
Hi all.
SCENARIO: in Book1. Sheet1 column A1 with value="Sheet2" column A2 with value="Sheet3" If my Cursor is at Column B1. I can use [=Sheet2!A1] to retrive the information store at Sheet2. A1 column here with my crazy idea come from now. hope it is achievable. If i would like to use this method [='A1'!A1 ]. It should derive the information from the Sheet2. Due to my A1 column is "Sheet2 " Instead it is prompting the Update value 'A1' Anyone use this before? -- Lawrence C H Tan Singapore |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Macro Help | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Combine 3 Columns on Sheet2 to Display in 1 Column on Sheet1 | Excel Worksheet Functions | |||
| Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Linear Mode
