Hi there

Is there a way to write a macro where you
1. Take a name from sheet A,
2. Find matching name in sheet B and corresponding comments with tha
name
3. Copy comments from sheet B and paste it back into Sheet A?

I need to do this continuously in a loop until all names have th
correct comments beside them. I used a For.. Next loop, but I'
confused with how to find, copy and paste the information using macr
functions.

Please advise.

Thank Yo

--
Message posted from http://www.ExcelForum.com