Hi, I really don;t know much about VBA but have a big need to do the
following: compare the contents in Column A sheet1 to the contents in
Column A sheet2, if matches found copy all the matches in sheet2
including all content in each of the rows of sheet2 to a new sheet.
Any help would be greatly appriciated!