Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to build a formula in a cell that runs a define name where the
name to be run is found in another cell. I have a master tbale which tracks cell formats for a 200+ column worksheet. When I add new cells or make some changes I need to change in all other cells as well. What I would like to do is create a generic formula in all cells that is the same ie =RunDefineName, this would be in all 200 columns by 5 rows. In the function I will refer to the master table (on a seperate sheet) which for this example has 5 rows. R1 would use defile name CALC_wk1 (this is the name you would see in the cell value) R2 would use defile name CALC_wk2 R3 would use defile name CALC_wk3 R4 would use defile name CALC_wk4 R5 would use defile name Total Now when =RunDefineName runs for row1 col1 it would get the definie name CALC_wk2 and run it as if I build the cell looking like =CALC_wk2. The biggest reason for this is I move a lot of the rows around and doing this would make it necessary to only move the MASTER table around. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Define Range Names in Excel 2003-SP2 | Excel Discussion (Misc queries) | |||
Invalid define names | Charts and Charting in Excel | |||
How do I find excel names that do not show in the define function | Excel Discussion (Misc queries) | |||
Define Names in Excel | Excel Discussion (Misc queries) | |||
how to define target frame names for the hyperlinks in Excel | Excel Programming |