Find and Replace function for VBA?

K

kamikazi

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
 
B

Bob Phillips

This sounds ideal for the macro recorder.

Try it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top