Gidday All
I have code that will look up a value in a column range in one sheet (target) against one column range over multiple sheets in another workbook (source) and paste the result into the same row of the target.
I have one sheet that i need to compare two column ranges in the target against the source, like an OR statement. when i run the original code twice it removes all the matches from the previous search.
Is there also another more efficient way of setting up the code so that I don't have to run this code multiple times for multiple sheets in the target workbook? Unfortunately the data to compare in the target workbook is not always in the same column range, nor where the result is pasted.
original code
Bookmarks