Kindly Suggest what is best and easy method for me as I am not that aware about the same,

requirement is the same same

say we searched for a word Text 1 (which will be macro asked) now it will search this is excel and what is corresponding value of text 1 is say xxx00, it copies from there, and ask to paste in word doc where Text 1 is there.

next it goes to find next, value say in sequence of Text 2 Text 3.....etc and repeat .... till CANCEL from user.

You know better then me, the solution, so suggest on that line only....

there is nothing related to mailmerge etc.

Thanks a lot Paul,