define names in excel
 

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

define names in excel
 

Not sure that it would solve all your questions, but there is a function
called CHOOSE which depending on the value of the first argument, returns the
nth + 1 argument of the function. As each argument can be a formula, this may
do the trick.