I have a workbook with several worksheets each containing codes in column A.
I read another file of codes and values, and for each line I want to find the code in whatever worksheet it appears and add the values into other columns.
How do I do a Find (or Match ...) across several worksheets?
I am trying
Sheets(Array("Alpha","Beta","Gamma"))
but what next? Columns("A:A").Find(... ?
I read another file of codes and values, and for each line I want to find the code in whatever worksheet it appears and add the values into other columns.
How do I do a Find (or Match ...) across several worksheets?
I am trying
Sheets(Array("Alpha","Beta","Gamma"))
but what next? Columns("A:A").Find(... ?