Bulk find and replace

0

I know ctrl h can find a single word or value and replace it on all sheets. Is there a way to take a list of value; vertical, and replace them with another list of various values?

Answer
Discuss

Discussion

No. There is no such way. However, you might employ VBA code to do that.
Variatus (rep: 1218) Sep 14, '17 at 8:56 pm
Add to Discussion

Answers

0

Check out the file attached.  You can use the VBA code, assign it a shortCut key and probably do what you need to do.  (I was confused by Variatus - 'No then Yes use VBA'. Good luck

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login