Basically what I am looking for is how to make this macro not copy the entire row of data but only copy/paste/delete the columns from the table (A:Y).
Here is the current macro:
Please Login or Register to view this content.
I will also attach the current spreadsheet so that you can get a better idea of what I am looking for. The reason I only want the table columns to be deleted is because anytime that I have to move an employee to the Terms tab, it moves up the dates that everything is calculated off of by 1, and causes issues with the rest of the sheet.
Thanks for any help you are able to give me as always.
2015 PTO tracker Hourly WIP.xlsm