Hi,
I have a worksheet, "Current Week", with a list of all staff in range A8:AA1003.
If a staff member has left in the previous 7 days, a leaving date is entered in column 'N', otherwise it's blank.
I need to remove all records of these 'leavers' (i.e. all records, A:AA, where N is not blank) on a weekly basis and append the records to the bottom of a list in a separate "Leavers Archive" worksheet.
Unfortunately my VBA skills are extremely limited and I don't have the first idea how to achieve this! Any ideas?
Many thanks in advance.
I have a worksheet, "Current Week", with a list of all staff in range A8:AA1003.
If a staff member has left in the previous 7 days, a leaving date is entered in column 'N', otherwise it's blank.
I need to remove all records of these 'leavers' (i.e. all records, A:AA, where N is not blank) on a weekly basis and append the records to the bottom of a list in a separate "Leavers Archive" worksheet.
Unfortunately my VBA skills are extremely limited and I don't have the first idea how to achieve this! Any ideas?
Many thanks in advance.