Hi, all,
My knowledge of Excel is at about an intermediate level, and I have very, very minimal exposure to macros. I'm hoping someone will be able to help me with this quandary.
I'm trying to automatically move rows in the attached workbook from FLOOR to either PD 2018, PD 2017, or PD 2016. Which sheet it is moved to is dependent on the date entered in FLOOR's Column M (Date Paid). If this is too complicated, the rows can just go to PD 2018 instead, and I can just filter by year. Lastly (as if I wasn't demanding enough), if after moving the row to the PD sheets, we need to reverse it, and move it back to FLOOR, would it be possible for it to do so just by deleting the Date Paid?
My sincerest thanks in advance for any help any of you can provide.
My knowledge of Excel is at about an intermediate level, and I have very, very minimal exposure to macros. I'm hoping someone will be able to help me with this quandary.
I'm trying to automatically move rows in the attached workbook from FLOOR to either PD 2018, PD 2017, or PD 2016. Which sheet it is moved to is dependent on the date entered in FLOOR's Column M (Date Paid). If this is too complicated, the rows can just go to PD 2018 instead, and I can just filter by year. Lastly (as if I wasn't demanding enough), if after moving the row to the PD sheets, we need to reverse it, and move it back to FLOOR, would it be possible for it to do so just by deleting the Date Paid?
My sincerest thanks in advance for any help any of you can provide.