LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Define Range Names in Excel 2003-SP2 Ian Excel Discussion (Misc queries) 1 October 27th 09 06:48 PM
Invalid define names Noreaster Charts and Charting in Excel 6 October 30th 08 01:48 AM
How do I find excel names that do not show in the define function Smitty Excel Discussion (Misc queries) 8 May 4th 07 04:16 PM
Define Names in Excel Dave T at home Excel Discussion (Misc queries) 2 November 1st 05 03:27 PM
how to define target frame names for the hyperlinks in Excel Chris Nicholas Excel Programming 0 July 10th 03 03:50 PM


All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"