Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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: 4889) 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