Specific Alphanumerics initiates a find & replace function

[gocolonel77]

Cell A1 will have a specific city name e.g. Troy, Celina, Piqua

If you look through columns C, G, K, O and T you will notice links that all come from the same file. Within the link is the name you will see in A1.

What I have found that works is a "find & replace".

All my links update correctly and everything appears ok.

What I would like to have happen is when I type the specific city in A1, it will automatically do a "find and replace" for whatever city I type in A1,thus updating all my links automatically.

I realize you might be thinking why not just edit the links to the file you want. The file I attached is small piece to a much larger workbook where the links are involved in numerous other worksheets within the workbook.

Hope this helps and thank you for your insights

[oeldere]

http://www.excelforum.com/excel-prog...25#post3379725

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.