View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bruno Bruno is offline
external usenet poster
 
Posts: 41
Default LOCATE DATA IN ONE SHEET AND APPLY ATTACHED DATA TO ANOTHER

I receive a list of numbers on an excel sheet and need to match it to info on
another sheet. EXAMP: Book 1, Sheet 1, Col 3 containes the numbers I receive
(6 digit). I need to quickly (and automaticaly, if possible) match the
numbers with numbers on Book 2, sheet 3, Col 4, and add the corresponding
info from Col 6 back to Book 1, sheet 1, Col 4.... next to the original
number.

Any help would be appriciated