I have an excel spread sheet that is designed to calculate a time schedule based on information. I would like a pop-up that would display after the schedule is created in show duplicate value conflicts. Here is the example...
Matt is working at 12:00 PM
Mark is working at 12:00 PM
I would like a box to pop-up saying Scheduling Conflict and show the name
Matt-Blank Box to adjust the time
Mark-Blank Box to adjust the time
I would like that time to fill into the cells that have the conflicting times currently in them.
Can I make this macro run after the schedule is completed and I'm ready to find the duplicate values throughout?
Thanks!!!
Matt is working at 12:00 PM
Mark is working at 12:00 PM
I would like a box to pop-up saying Scheduling Conflict and show the name
Matt-Blank Box to adjust the time
Mark-Blank Box to adjust the time
I would like that time to fill into the cells that have the conflicting times currently in them.
Can I make this macro run after the schedule is completed and I'm ready to find the duplicate values throughout?
Thanks!!!
