So I'm a novice at excel and I am trying to create a scheduling system for my manager. There will be a front end that contains a calendar and a backend that contains a chart that is used to filled out the calendar. The chart has a "begin" and "end" day that signify the start and end of a trip. Each day of the trip will be filled out on the calendar in with a color depending on location. Is there a way to do this without VBA? if there isnt can someone help me out with the code? its been 5 years since ive looked at visual basic and i never applied it to excel. The first file calend_dlroo is the actual calendar. the second file CEConfigOutput is the data i am importing. I have a macro that executes on open that refreshes the data in the calendar.
Thanks
calendar_dlroo.xls

CEConfigOutput.xls