I need help. Whoever helps me get this gets a prize. I am trying to make a macro that will look through a column and copy & paste rows that match a certain criteria to a certain sheet in the workbook.
ie. if A1 = "A" then it would paste the entire row into sheet2, if A1 = "b" then it would paste the entire row to sheet3.

The part I am having the most trouble with is figuring out how to make it paste in the first open row and not over-write something already filled. If it would help to give you what I have so far let me know. THANKS!