Pickup word from 1st word document and search for them in 2nd document.
Hello
I’m looking for a macro that will pickup word from doc-1.doc and then search them in doc-2.doc and if it finds that word in file doc-2.doc then cut out that whole line and paste in a new window doc-3.doc, then go back to the doc-1.doc and delete that row that was already searched and search for the next word.
So e.g doc-1 contains the word Plans, so it should search for that word in doc-2 and if it find it then cut out that whole line and place it in doc-3 window, after that delete Plans and then search for loan broker and keep looping it until no more words to pick up from doc-1.
Any help will be greatly appreciated.
Thanks.
|