Data Validation / find & replace

P

Penny

If I can one entry within a list set-up using Data Validation, how do I get
it to up-date automatically wherever the original selection has been made?
Example: list has:-

Hello
Goodbye
Thanks

I change Goodbye to See Ya ... now I want everywhere that has Goodbye in it
to change to See Ya without me having to go and make the change ... this may
be in more than one workbook so am assuming that if I was to use
find/replace, I would have to open each workbook individually and repeat
process? Or can you use find/replace on closed workbooks?
 
J

Jim Rech

Or can you use find/replace on closed workbooks?

The workbooks have to be open.
--
Jim
| If I can one entry within a list set-up using Data Validation, how do I
get
| it to up-date automatically wherever the original selection has been made?
| Example: list has:-
|
| Hello
| Goodbye
| Thanks
|
| I change Goodbye to See Ya ... now I want everywhere that has Goodbye in
it
| to change to See Ya without me having to go and make the change ... this
may
| be in more than one workbook so am assuming that if I was to use
| find/replace, I would have to open each workbook individually and repeat
| process? Or can you use find/replace on closed workbooks?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
Access 2002 change report header text 0
Data Validation "The Source Currently Contains an Error" 0
Data validation on data validation function 1
Use Find and Replace in Excel 1
Using Data Validation in a Table 0
Find and Replace variable string 15
Locking Pages and/or Workbook 1

Top