Calendar data exchange between Excel and Google Calendar
$30-250 USD
En curso
Publicado hace casi 13 años
$30-250 USD
Pagado a la entrega
Will need skills with Excel, VBA and Google Calendar API. I need the ability to 'admin' this system to make minor changes without performing a compile (or if can be done in VBA - great, I can handle that).
We use a spreadsheet to track our contracted projects. Among other things, the spreadsheet includes project start and end date and times. We also generate 'calendar event detail' using a simple formula (project name, project type, etc). Today we manually create Google calendar events for each project entry in the spreadsheet. We need to automate this process. The project scope is fairly limited:
Must Have: if a column has an 'x' in it, use the data in that row to 1) search the Google calendar to see if the event is already scheduled and 2) create or modify the Google calendar entry based on the data from the 3 columns in that row (date/time/event name)
Nice to have: Create an 'update spreadsheet' function to search a date range in Google Calendar and then populate 3 columns for each Google Calendar event that isn't in the excel spreadsheet
Be really neat: In addition to creating a calendar event in a master Google calendar, it would be great if a duplicate calendar event could be created for the individual associated with the event in their personal calendar.
**Please specify if your bid includes 'Must Have', 'Nice to have', 'Be really neat'
Hi,
I am Experienced Excel VBA [login to view URL] can check my [login to view URL] Addition to Excel VBA, I have also experience of integrating G-Calenders with custom [login to view URL] check your message box for more details.
$180 USD en 4 días
5,0 (61 comentarios)
5,2
5,2
10 freelancers están ofertando un promedio de $147 USD por este trabajo
Dear Sir:
What means 'Must Have', 'Nice to have', 'Be really neat' here?
If you can provide an xls sample,I'll complete the codes for you within 5 days.
See PMB please.
Dear sir
i am interesting in doing this job. pls give me an opportunity to do this & 'Must Have', 'Nice to have', 'Be really neat' are available in my skill.
Thanks
Dear sir,
1. 100Mbps speed internet
2. Good typing speed with minimum 32 WPM
Hi sir, I will complete your work with 100% reliability at the correct time. I am liking to do this work for long time.
we can face a very big projects,
we many partners so we can complete your project earlier and successfully
without any mistakes.