Move a Rowto a section based on the date

[-EA-]

I am under a tight deadline to get a product out and cannot figure it out. I want to figure this out without a macro, becaused I am clueless with those. But if that is what needs to be done, then so be it. Basically what I need to do is have the section "Future Leave Requests" (rows83 and below) filled out, when the departure date hits, then the row would need to move up to the "personnel on leave" section (Row10-36).

Same thing goes for the TDY section, the future section (rows 168-182) move up to Current TDY (rows40-55).

Even if it had to be two sheets to make it easier, I would be fine with that.

Would I be able to add in rows as needed without screwing it up?

Thanks for any and all help.

[herbie226]

Hello,

Just to ensure I am understanding what you want. Your plan is to fill in the "Personnel On Leave (Off Pen and Outside 3-Hr Response)" section and have the rest of the sections auto populate. Correct?

[-EA-]

I want to only fill out the section that is "Future leave", then when their departure date comes up, the row would autopopulate into the "personnel on leave" Section.
Same for the TDY, only fill out the "Future TDY" section, and then when the departure date hit, it would move up to the "Personnel TDY" section

Thanks for the quick response.

[herbie226]

Hello, not sure your method of solving your issue but I put this together for you. Not the most pretty code but it should assist you.