| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic formula? not sure if it's even possible to do this with Excel ...
I think the easiest way is the function 'Indirect'
=INDIRECT(A1&"!B3",TRUE) If cell A1 is 'Internet' (w/o the quotes) then this will return the value in cell B3 on that sheet. To get the name in A1 you can use =CHOOSE(A2,"Store","Food","Internet") with A2 being the cell you linked to the option buttons DQ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic pivot table linked to dynamic excel spreadsheets | Excel Worksheet Functions | |||
| Dynamic Formula with Dynamic Address | Excel Worksheet Functions | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Excel Programming | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Hybrid Mode
