Hello,

I have a workbook that has many different worksheets. Each worksheet represents a location, and within that worksheet, the user will specify in Column B which dates they will visit that location.

I want to create a calendar that aggregates all of this information into one worksheet, and allows the user to see in calendar format their schedule of visits. This will allow them to see if they are going to multiple locations on one day and if they need to reschedule or plan again.

Any help in creating a macro for this is greatly appreciated.

Thanks,
NdnInformer