Filter records, paste into a different sheet, delete rows from original sheet.

Please could somebody help me?

I have designed a spreadsheet to track orders.

When the tick box is clicked in the Order Tracking worksheet, todays date will apear in the 'Invoiced' column.

When date is in the 'invoiced' column, the whole row needs to be moved into the 'Invoiced worksheet'.

This row then needs to be deleted from the Order Tracking worksheet, otherwise the spreadsheet will become too large.

I have done an advanced filter to filter the records so that only those with dates in the 'Invoiced' column show, and know how to copy/paste. It is deleting the row from the original sheet and getting it to paste underneath the data already pasted on the Invoiced worksheet, that I have no idea how to do! (This will be done on a daily basis and so will be continuous)

Any help will be greatly appreciated.

Many thanks

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!