I am trying to create a program either in VBA or if possible by excel formulas to sort data values from a table into 2 different calendars. I would like to use it to sort scheduled items for 2 staff members. I have been able to take a table of raw data and extract it down to the data I need to sort, but cannot figure out how to sort it into the calendars. Maybe something like this has been posted already but I am not able to locate it.

Ultimately i would like to create macros to import the raw data table into a spreadsheet where it is to be narrowed down to just the data I need and then have it export into a new workbook 2 calendars with the data sorted.