Search for multiple duplicates and return value in new list

[Peaceless]

Hi all!

I have tried to solve my issue with formulas like Index and Match but have not been able to do this in any efficient way unfortunately so I am turning to you to seek help. I guess I need to solve this with a macro.

I have two workbooks, one which I work in (wb1) and one with all the data (wb2). In wb1 I have a list of values, I would like to search wb 2 for matches in a specific column in predetermined sheets in that workbook. When a match is found, I want a different cell in that row to be copied in to a specified cell in wb 1. There might be several matches in wb 2 in different sheets as well. Every value in the list in wb 1 will have at least one match in wb 2. There might be values in the list in wb 1 that matches within the list as well and ideally I´d only want one output as they later on will be sent out in an e-mail.

Any suggestions on how I would go about to solve this?

Thankfull for any help!

kr,

Åsa

 

[Peaceless]

hmm, yes I did change the name...

 

[Peaceless]

I think that your suggestion is too complicated for me to modify, my knowledge is too limited even changing from a message box to copy paste in another workbook seems too hard for me to. I really thank you for your time though, hopfully someone else might have a solution...