an Shout out to all Excel Wizards!!


My Problem, take populated cells from column A of sheet 1 and search
and copy rows from sheet 2 that match the certain of column E, and
paste full rows to sheet3 until all cells in sheet 1 have been used up.
Im trying to have it run from VBA with a button on sheet 1 or a macro.

this is what I have to work with.

Sheet 1 (Paste in UserID numbers, ending row varys)
Column Names Column Letter
UserID----------------------A


Sheet 2 (All Records, updates monthly, ending row varys)

Column Names Column Letter
FirstName -------------------A
LastName--------------------B
UserName-------------------C
Password--------------------D
UserID-----------------------E

Sheet 3(Generated back on search results "Rows" found from Sheet 2)

Column Names Column Letter
FirstName -------------------A
LastName--------------------B
UserName-------------------C
Password--------------------D
UserID-----------------------E


Thank You in advance for your reading time and of any help you could
provide!!

~ Marc