Compare Lists and Copy Duplicates

[helpexcel]

Hi - I found a few threads on this topic, but I'm struggling. I have 2 lists, Sheets1 Column A and Sheets2 Column B. What i'd like to happen is if the item on Sheets1 appears on Sheets2, then copy the whole row (columns A:E) to Sheets3 A6. I would be running this code mutliple times so if i could get it to copy to next available row would be great. Playing with a bunch of different codes, at some point this stuff will make sense to me.

Thanks!!

 

[helpexcel]

I think I figured it out. I can just resort the list and that would put the blanks at the end. Sorry for giving you the run around and thanks for the help!!!