I have two sheets and both with ID's and Names. I only need 50 of the ID's
and Names but they are specific that I need out of the other sheet that has
all 750 ID's with names. Instead of doing a find and copy and paste into the
new sheet is there anyway to compare the two and put the values that I need
to the left of the column B in Sheet 1 and place the ID's in Column A of
sheet 1 out of Sheet 2 (Where all the data is found but I only need the 50
and not the 750 that are unique)