Schedule Converging
Coding Gods,
I am currently trying to solve a problem that my upper management has given me. They have a training schedule that has different sheets for different departments in the company. Once each department has uploaded to the workbook, they want all the individual departments to merge into one master sheet with everyone's training events. In the example posted below I would need the IT and LOG sheets to populate to the master sheet (in the correct time/date order and in the same format). Keep in mind, the number of events for a day is dynamic. One day could have four events and the next could have only one. I am no VBA master by any means and am struggling to find anyone with the same requirements. Any help with the example would really help me. I know, there are multiple other resources that would be much easier and feature rich but this is the way they want it done. Once again, thanks for your help!
|