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