Find and Replace function for VBA?

  • Thread starter Thread starter kamikazi
  • Start date Start date
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word to Excel: Export comments with text and line number 0
A simple if <> nn then Msgbox "No Match" 5
Create if partial match then copy and paste data from one cell to another 1
How to hide password? 1
Copy/Paste and remove blanks VBA 0
Excel VBA help: Text file formatting 19
Find matches in different spreasheets then copy and paste to new s 15
Change event code Find .Activate does not activate Target.value 4

Back
Top