Schedule Builder Automatically move personal to PTO/STD Section based on a calendar stored

[meabrams]

What I am trying to accomplish is once a button is clicked on the Schedule Sheet a macro runs and moves personal to PTO/STD column if they are listed on PTO Calendar Sheet as PTO/STD and Places a “OT” in their spot and if they are no longer on PTO then Move them back to their proper Area based on Personal Sheet…. Sorry if this sounds confusing… If you need me to I can try to clarify what I’m trying to say