Hi there,
I have the following data in an Excel spreadsheet:
Cell A1: 21-Jun-20 (this is the entry date)
Cell B1: 09:00 (this is the start time)
Cell C1: 10:00 (this is the end time)
Cell D1: Joe Bloggs (this is the entry name)
The subject spreadsheet comprises 15 worksheets, 12 of which are for each month of the year
Each worksheet has several entries similar to the above, with a varying quantity of entries in each, along with varying start/end times for each entry
If I were to create a new Google calendar, I wondered if it would be possible for all entries in the Excel spreadsheet to update that calendar every time an entry is inserted, as above, or whenever existing entries are modified (in the spreadsheet).
Any assistance would be gratefully received.
Best wishes,
Ketan
I have the following data in an Excel spreadsheet:
Cell A1: 21-Jun-20 (this is the entry date)
Cell B1: 09:00 (this is the start time)
Cell C1: 10:00 (this is the end time)
Cell D1: Joe Bloggs (this is the entry name)
The subject spreadsheet comprises 15 worksheets, 12 of which are for each month of the year
Each worksheet has several entries similar to the above, with a varying quantity of entries in each, along with varying start/end times for each entry
If I were to create a new Google calendar, I wondered if it would be possible for all entries in the Excel spreadsheet to update that calendar every time an entry is inserted, as above, or whenever existing entries are modified (in the spreadsheet).
Any assistance would be gratefully received.
Best wishes,
Ketan
