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

Y

yamatoblaze

Joined
Nov 14, 2012
Messages
1
Reaction score
0
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!
 

Attachments

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Multiple worksheet Copy Paste Macro 2
Copy to another worksheet 3
Find and TRansfer from another Tab in same Worksheet 3
Selecting all cells with content using a variable 3
Excel Macro to hyperlink an archived worksheet to an index page 0

Back
Top