Copying data from one sheet to another

[monkeenutz]

We currently record all cheques received on a spreadsheet, and wish for the information on the entire row to transfer over to a new worksheet “chasing up workbook” if various parameters are not correct and then remove itself again once processed. The reason for this is to ensure that every payment is processed, and chased up if it hasn’t been processed within the 14 days.

Column C has the Date it was received (I want it to copy over when over 14 days from today’s date)
And if Column H or I is blank.

Also I want it to remove itself from the “chasing up work book” if/when these details are then filled in (column H and I).

I have no idea what is the best way to do this whether so any assistance is appreciated

[royUK]

Why not just filter the data?