I need to enter leave for all my employees for our christmas closedown.
I have a list of staff numbers and then I need to insert lines with the time off dates
eg
Simple staff list downloaded:
105284
105239
005683
etc
Need it to end up being like this table below so that I can upload it into our HRIS system. So at each change in employee number I need to insert 3 columns with Date, time off category and amount, with the dates as set below and each individual line needs to have the employee number. As it will be a csv file, I need to keep leading zeroes, and the date needs to be in the american format mm/dd/yyyy.
I would really appreciate your help. I have tinkered for a while and can do certain things like insert lines and do offsets and copy data, but I've lost my way adding in the employee numbers in each row. Macros are definitely not my strong suit I'm afraid.
I have a list of staff numbers and then I need to insert lines with the time off dates
eg
Simple staff list downloaded:
105284
105239
005683
etc
Need it to end up being like this table below so that I can upload it into our HRIS system. So at each change in employee number I need to insert 3 columns with Date, time off category and amount, with the dates as set below and each individual line needs to have the employee number. As it will be a csv file, I need to keep leading zeroes, and the date needs to be in the american format mm/dd/yyyy.
I would really appreciate your help. I have tinkered for a while and can do certain things like insert lines and do offsets and copy data, but I've lost my way adding in the employee numbers in each row. Macros are definitely not my strong suit I'm afraid.
| Employee # | Date | Time off category | Amount |
105284 | 12/25/2022 | Annual Leave | 0 |
105284 | 12/26/2022 | Annual Leave | 0 |
105284 | 12/27/2022 | Annual Leave | 1 |
105284 | 12/28/2022 | Annual Leave | 1 |
105284 | 12/29/2022 | Annual Leave | 1 |
105284 | 01/03/2023 | Annual Leave | 0 |
105284 | 01/04/2023 | Annual Leave | 0 |
105284 | 01/05/2023 | Annual Leave | 1 |
105284 | 01/06/2023 | Annual Leave | 1 |
105284 | 01/07/2023 | Annual Leave | 1 |
105284 | 01/10/2023 | Annual Leave | 1 |
105284 | 01/11/2023 | Annual Leave | 1 |
105284 | 01/12/2023 | Annual Leave | 1 |
105284 | 01/13/2023 | Annual Leave | 1 |
105284 | 01/14/2023 | Annual Leave | 1 |
105284 | 01/15/2023 | Annual Leave | 1 |
105239 | 12/25/2022 | Annual Leave | 0 |
105239 | 12/26/2022 | Annual Leave | 0 |
105239 | 12/27/2022 | Annual Leave | 1 |
105239 | 12/28/2022 | Annual Leave | 1 |
105239 | 12/29/2022 | Annual Leave | 1 |
105239 | 01/03/2023 | Annual Leave | 0 |
105239 | 01/04/2023 | Annual Leave | 0 |
105239 | 01/05/2023 | Annual Leave | 1 |
105239 | 01/06/2023 | Annual Leave | 1 |
105239 | 01/07/2023 | Annual Leave | 1 |
105239 | 01/10/2023 | Annual Leave | 1 |
105239 | 01/11/2023 | Annual Leave | 1 |
105239 | 01/12/2023 | Annual Leave | 1 |
105239 | 01/13/2023 | Annual Leave | 1 |
105239 | 01/14/2023 | Annual Leave | 1 |
105239 | 01/15/2023 | Annual Leave | 1 |
