Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Updates
Hello,
I start with a list of text, a, b, c, d, e, f, g etc that I turn into a drop down selection list using the data validation. The user then fills in the sheet with whatever other fields they need. However supposing I need to change d to z on the input list I am stuck with data based on the old list. Is there a way that when I update the inputs I can get excel to automatically go back through the filled in data and replace all d with z in the table? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data updates by clicking and dragging bar graph | Charts and Charting in Excel | |||
Data Updates With Date | Excel Discussion (Misc queries) | |||
Macro: Updates a formula or value when a data is entered. | Excel Worksheet Functions | |||
A Chart that Updates Automatically as Data Size Changes? | Charts and Charting in Excel | |||
Is there a way to automatically add columns as the data updates? | Excel Worksheet Functions |