| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to reference sheet number base on cell
I've done this before, but I can't remember how. I need to reference a
sheet number based on another cell. For example: ='Sheet1'!A1+A2 In my situation, I need to reference the Sheet number where the number will be in a cell. Let's say that the number "1" is in A5. In my formula above I need something that will say Sheet & A2 which will be "Sheet1". How can I do this? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I reference a cell as a row number in a formula? | Excel Discussion (Misc queries) | |||
| How to reference or redirect a formula in a base row? | Excel Worksheet Functions | |||
| Use cell value as reference to sheet in formula? | Excel Worksheet Functions | |||
| Changing Cell Reference in a macro on global base | Excel Discussion (Misc queries) | |||
| Need formula for sheet & cell reference | Excel Worksheet Functions | |||
Threaded Mode
