I have a list of data on one worksheet, I want to compare the values in this
list of data with values in another column of a different worksheet. When
there is a match between these values I would like to copy the row from the
second worksheet to a completely different worksheet. I have seen some
examples of finding data, and copying data, but do not really have a full
enough understanding of the principles to make this work. In a nutshell I
want to look at sheet 1 column A, compare these values with sheet 2 column M
and if there is a match found copy the row that contains the match from sheet
2 to sheet 3. Can this be done?
Thank you for any assistance you can provide.