View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mully
 
Posts: n/a
Default Searching Columns

Hi All

Is there a macro or routine that will search a list of code numbers in
column "A" of Sheet1 then search 10 other sheets for the Codes and add
information from Columns "B" & "C" on Sheet1 to the first empty column that
it finds the correct code from Sheet1. Sheet 10 also has a list of the codes
and I need to exclude the search and inserting information on to Sheet10.

Thanks

Mully