Macro: finding a cell on one worksheet and copying to another worksheet

Nov 14, 2012
Reaction score
Hi there, I find myself in need of a macro to combine data from two lists and I have no idea how to do it.

I've attached a zipped spreadsheet.

What I need is a macro that takes each partner name in column A of the first tab and searches for that partner name within the second tab.

If it finds a match, it then copies the contents of the cell it finds (it must be the entire file path - see the example) into column B.

So for instance, if A2 on the first tab is "AK Electronics" then IF it finds "AK Electronics" anywhere in column A of the second tab, the contents of the cell it finds would be copied to B2 on the first tab.

If it finds nothing it can return a blank, or "FALSE", or anything really so I can easily filter out anything without a match (although if you can make it remove them as part of the macro that would be great).

Can anyone help me with this?

Thanks very much in advance!


  • file
    6.1 KB · Views: 98


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