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
|