Hi All

Is there a macro or routine that will read a list of code numbers in col"A"
of Sheet1 then search and find the same code numbers in another 10 sheets in
col"A" then place the information in cols "B" & "C" of Sheet1 in the first
empty col when it finds the code number in any of the other Sheets. Sheet 10
has a complete list of the same codes and I need to exclude it altogether
from the original search

Thanks

Mully