Calendar date exchange between Excel and Google Calendar
$30-250 USD
Closed
Posted almost 13 years ago
$30-250 USD
Paid on delivery
Will need skills with Excel, VBA and Google Calendar API
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 have gone through your requirement and I am glad that I can accomplish
this task, Please give us an opportunity to work with you.
Thanks,
Tamrakar
Dear Hiring Manager,
I was excited to read about your administrative job opening. I have several years of experience in a variety of fields such as accounting, finance, insurance and including Human resource and writing and re-writing of articles.
In addition to my office experience, I have a strong communication, customer service and administrative skills. My broad background makes me an excellent candidate for the position.
Thank you for consideration. I am looking forward for an interview and to work with your company.
NICE TO HAVE.
Respectfully yours,
Charity Ibay
I have a pretty good hands on with VB, VBA, Microsoft technologies and Internet applications. MS Excel has/is been my daily routine. I can cover all the three options Must/Nice/Neat within the price that is quoted in my bid.
Looking forward to work with you.
Thanks,
Prema