| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula with dynamic tab reference
I have a workbook with 50 tabs and would like to write a formula that pulls
data from a set cell range but across different tabs. I'd like it written in a way where a cell (on the summary sheet) occupys a tab name and that cell will be referenced in the formula so that if I change the name, the formula knows to pull from a different tab. No macros please. Thank you, Charlie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Help with Formula Reference Point | Excel Worksheet Functions | |||
| Is it possible? | Excel Worksheet Functions | |||
| "Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
Threaded Mode
