Find and Replace function for VBA?
 

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

Find and Replace function for VBA?
 

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)

"kamikazi " wrote in message
...
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 that
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 the
correct comments beside them. I used a For.. Next loop, but I'm
confused with how to find, copy and paste the information using macro
functions.

Please advise.

Thank You


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