I have a sheet called "Control" wherein cells I12:I13 where it shows who the next person is for the Sup line. In cells M12, I would like to put the date that it is completed for & on cell change for it copy the date over to sheet "Escalation Rotation" in column B beside that person's name. Just for the 1st blank cell so their name is back in rotation when it comes up again. Any help would be greatly appricated & I have attached an example for your reference.
Put this code in your Control Sheet module - it does only what you specified:
Please Login or Register to view this content.
Last edited by xladept; 02-18-2018 at 04:02 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks