Move row from one sheet to another based on date

FloJoMoJo

New member
Joined
Mar 12, 2018
Messages
1
Reaction score
0
Points
0
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. :)
 

Attachments

  • Floor Plan Draft.xlsm
    39.1 KB · Views: 9

Attachments

  • Floor Plan Draft_v2.xlsm
    45.9 KB · Views: 14
Back
Top