Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating cells which reference a defined name
I am using defined names as a validation criteria for cells in a
workbook. I have a worksheet that will contain the list of all facilities and a seperate worksheet that will contain the realationship between the facility and locations within the facility. Example: Defined Name Facility Code ABC DEF EFG Now I have a seperate sheed that will identify various things at the particular Facilities Example: ABC - Boardroom ABC - Cafeteria What I want to know is if the code of ABC in my defined name is changed to say ABC123, how can I automatically update the reference in the worksheet that uses this defined name as a validation criteria? Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating cells which reference a defined name
You could do this with programming. There's a sample file here, that you
may be able to adapt to your workbook (test it on a backup copy): http://www.contextures.com/excelfiles.html Under Data Validation, look for "DV0022 - Update Validation Selections" Mike Miller wrote: I am using defined names as a validation criteria for cells in a workbook. I have a worksheet that will contain the list of all facilities and a seperate worksheet that will contain the realationship between the facility and locations within the facility. Example: Defined Name Facility Code ABC DEF EFG Now I have a seperate sheed that will identify various things at the particular Facilities Example: ABC - Boardroom ABC - Cafeteria What I want to know is if the code of ABC in my defined name is changed to say ABC123, how can I automatically update the reference in the worksheet that uses this defined name as a validation criteria? Mike -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Can I link cells to a reference table I make? | Excel Discussion (Misc queries) | |||
Expanding conditional formating with reference cells changing | Excel Discussion (Misc queries) | |||
3 cells are named - how to refere to them in one reference field in a chart | Charts and Charting in Excel |