I have two sheets, one that I add information to and one that is a summary of the completed information from sheet 1. Once I add 'completed' into column A, I want that row's data to paste into the next available row in sheet 2. So, what I would have in sheet one is everything but in sheet 2 is just the completed items. Is there a way to do this?

Thank you,
Jaime