Hi,
The company I work for manage a holiday log through excel and have asked if it is possible to automatically update this information into a shared outlook calendar. The spreadsheet contacts a list of dates along row 4 (E4:NE4) one column for each date. And a name for each person in the company in column A (A4:A15 etc) with a 1 under each date a person might be on holiday. Is it possible to automatically update this information into a shared calendar in outlook on closing the spreadsheet?
The company I work for manage a holiday log through excel and have asked if it is possible to automatically update this information into a shared outlook calendar. The spreadsheet contacts a list of dates along row 4 (E4:NE4) one column for each date. And a name for each person in the company in column A (A4:A15 etc) with a 1 under each date a person might be on holiday. Is it possible to automatically update this information into a shared calendar in outlook on closing the spreadsheet?
