Hi guys I'm hoping if anyone could provide me assistance. I have a table in worksheet 1 with data in rows 3 to 1000 and columns A to P. If column P holds a date for any row I need to copy the full row, paste the row to the next available row in worksheet 2 and then delete the appropriate rows from worksheet 1. I have a basic understanding of vba and any help to achieve this would be appreciated