Search, Copy and Paste

[japorms]

Guys,

Can anyone help me create a macro that do search, copy and paste? I tried searching for an existing one but there's no macro that matches to what I need. Basically, the macro needs to look in sheet2 column B, the data that it needs to look for is in sheet1 column a, once it finds the data in sheet2 column B, the original search criteria needs to be paste starting in sheet3 A1 while all the found data needs to be paste in column B. It will then proceed to look for the next data in sheet1 column once it's done searching on the first item. I can't even think how to start with this one, it's too complicated for me. I attached a sample data. The search data is in sheet2 and the lookup data is in sheet1.

[Leith Ross]

Hello japorms,

How do you want to handle duplicate data?

Sincerely,
Leith Ross

[japorms]

Hello japorms,

How do you want to handle duplicate data?

Sincerely,
Leith Ross

it can be deleted.

[Leith Ross]

Hello japorms,

Sorry for the delay, my computer decided some of my software needed to updated. I added a button on Sheet3 that will perform the copy paste. Only the unique entries on Sheet1 are copied to Sheet3. A search is done on Sheet2 for each of these entries. When a match is found, the data from column "B" of the search result is transferred to column "B" of Sheet3 in the same row of that search term. This macro has already been added.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[japorms]

Thanks for the code but it didn't really answer my needs. I decided to use access to combine two data from excel. Thanks!