Hello All,

I'm a newbie Macro user and have been trying to learn as I go. I've managed to find a way of searching documents to copy multiple words and paste into another blank document (may be easy but I was pretty excited). I now have a more complicated task that I am hoping to make easier with a Macro, however it is well beyond my capabilities.

Task:
I need to "search" and entire document (header, footer, body, sections, tables, etc) to find part numbers that begin with "A_" or "B_" since these are old part numbers. The underscore (_) is part of the number. I have a spreadsheet with the NEW part numbers that I need to replace the old ones with. I'm reading that it may be similar to another thread but I am not proficient enough to adjust it for my needs. Can someone assist me adjusting the macro?

Thread I read through: https://www.msofficeforums.com/word-...sing-word.html

I need it to:
- Pop-up a window so that I can type "A_" and have it find all part numbers that begin with that.

- I can define the location of the worksheet, which contains a column with the part numbers, and embed the file name and location in the Macro (if you help direct me to the spot in the macro).