Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Lists - Allowing no other entries
I am using a drop down list for categorization, however, frequently the
category titles change, is there a way to force the data to change when I update the master list? Currently I have to change each entry in my register to match the new category title. This isn't too hard as I can use find and replace, but I would like the entries with the old title to no longer be valid and be forced to be updated. Also, can I have the cells auto-fill from the list? -- KKD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - allowing only negative numbers or converting | Excel Discussion (Misc queries) | |||
Data Validation - Only Allowing certain characters | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Compare two lists of data to find new entries | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) |