I have a table starting from Column B to G and it has date (for validation purpose) in column D.
What i am trying to achieve is move data of rows whose date is past today to another sheet.
i want to delete only table rows not the data in column A as it contains Serial No.
i am able to do copy and paste or delete the rows but it delete's the complete row thereby upsetting the sequence number.
please help me with the code.
Thanks n regards