Excel data to osx calendar

[serhito]

Hi,
I am trying to extract my schedule from an excel spreadsheet and send it to icalendar, or just extract the info and create a new spreadsheet with just MY info.
I have attached a file, to show how the info can be spread out throughout the spreadsheet.
Basically needs to look in each column 1,2,3, etc...(day of the month), find "SMITH", use location "BUILDING 1", times "0930 until 1330", notes "A" and "B".
Spreadsheet is for November
Send that info to ical.

Also, is there any way to first delete the ical calendar before sending the info ? This way, if there are any changes, it would just replace everything. (I get a schedule update every day)

Thanks for any help.


Attachment 647353