- 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!
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!