Hello
I am trying to create a macro that will essentially reset a line for payroll tracking.
So I have a Rate of Payroll List in C4 that states if the payroll is monthly, bi-weekly, or weekly. I have a Date of Payroll Cell in D4. And I have a Date of next payroll in G4.
What I want the macro to do is:
A) take the date of next payroll and paste it into Date of Payroll. Basically just move it over after I completed the current date. *I have done this*
B) by way of if functions, I want the macro to read what the Rate of Payroll (C4) list is and create the next date in my Date of Next Payroll (G4) cell.
I want this to help keep track of various client's needs and save time by having it reset at the click of a button.
Any help is greatly appreciated.