Automated Excel Calendar from Outlook

Encerrado Postado há 7 anos Pago na entrega
Encerrado Pago na entrega

Background:

We have a weekly meeting that we all sit around and dish out our schedules and manually input them into a master excel sheet. This is inconvenient, time consuming, and inefficient. We would like to automate the process.

What we need:

Outlook Calendars (7 in total) -> Master Excel Sheet -> Member Schedule Excel Sheet

Outlook needs:

1) We need all 7 outlook calendars to go into one single excel sheet. We want it to happen on a weekly basis on Fridays.

2) The excel sheet needs to have variables for the owner, category, subject, start date, end date, attendees.

a. This is already in the code below

3) The code below needs to be edited to where it is automatic and not manual. At the moment we have to manually select the dates that the code draws from on the calendar. We want it to be an automated process to take place every Friday evening.

4) Also, we have a system of classification in place to say if the file is confidential or not. This has caused problems with the code when trying to save since it cannot tell the program what to do. This is a minor problem that we could probably work around, but would be nice to have it automated as well.

Master excel sheet needs:

1) The 7 calendars need to be imported into this one sheet

2) The variables mentioned above should be the columns

3) The code below does this well, but as mentioned, we need it to be automated

Member Schedule Excel Sheet:

1) This excel sheet has a list of the members with dates by day and month.

2) We need this excel sheet to be filled based on criteria from the master excel sheet

a. Example: if Person1 has a vacation scheduled for 02/04/2017 to 02/10/2017, we need the corresponding boxes filled with a “V” on those dates for that person inside of the excel sheet.

3) The criteria needed for the sheet is:

a. Date of event matches on both sheets

b. Owner of Calendar matches Person (this will have to be searched by keyword… example: First Last on the Member Schedule Excel sheet will be displayed as “[login to view URL]\calendar “ on the master excel sheet.)

c. Look for certain keywords (ie. “vacation”, “personal”, etc… we will set these) inside of the master sheet subject box column to determine if the specific date and person has added is a vacation day, personal day, half day vacation, etc. This command should fill in the sheet with the appropriate symbol to indicate what type of day it is

d. If an event contains 2 or more of the Persons, then the column should be yellow with “Major Events/Meetings” being filled with the name of the event

4) The criteria need to return the correct code corresponding with the correct person, date and event

5) If an event is more than one day, the master excel will only have the start date and end date, we will need for all days in between to be highlighted with the correct symbol.

The uploaded file contains the same information plus images.

We have anticipation of more projects in the future and would like to find a freelancer to stay with us on these.

Excel Microsoft Outlook

ID do Projeto: #12510972

Sobre o projeto

15 propostas Projeto remoto Ativo em há 7 anos

15 freelancers estão ofertando em média $409 nesse trabalho

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Mais

$950 USD em 1 dia
(438 Comentários)
8.3
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y Mais

$400 USD in 7 dias
(392 Comentários)
8.1
maverick44000

Hi Sir, I have gone through the entire description and I shall like to know a few things which are not mentioned. Besides, instead of VBA code, I can develop a professional .Net Outlook Add-in for all 7 users which Mais

$800 USD in 4 dias
(109 Comentários)
7.7
someka

Hi. I can work on your outlook-excel communication macros. We can also create the necessary code in Excel, so that your output is more user friendly and easy to use for your meetings. And yes, my offer is 1000. Let me Mais

$1052 USD in 2 dias
(141 Comentários)
7.2
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea Mais

$500 USD in 15 dias
(115 Comentários)
6.3
satishtl

- Have done similar outlook automations, getting calender and task events from outlook to Excel. Can showcase. - Gone through the description and the doc of getting the 7 calendar events and marking them in Master and Mais

$500 USD in 5 dias
(50 Comentários)
6.1
nurnga1218

I didn't have expert experience in Outlook, but I use it daily. It's not a difficult thing for me. and I am an excel expert. You give description obviously, You don't have to wait any longer. 50$ milestone and your p Mais

$55 USD in 2 dias
(42 Comentários)
4.7
SergeyKyiv

Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and Mais

$145 USD in 7 dias
(9 Comentários)
4.4
bddurkin2

I have done essentially this exact same thing before using Power Query in excel. Power Query can be used to read Outlook data, including all the fields you've mentioned. The update could be made to occur in real time Mais

$333 USD in 3 dias
(0 Comentários)
0.0
mekarmeina

my experience as a project engineer will meet your requirement. please see my portfolio for sample.

$250 USD in 6 dias
(0 Comentários)
0.0
atifcomp

Please don't judge my profile with ratings. I have handsome experience working with data of around 5 years. Most of the projects i do is of data analysis, so I have understanding of data as well. I completely underst Mais

$88 USD in 8 dias
(0 Comentários)
0.0
Surajmsn

excel expert

$277 USD in 7 dias
(0 Comentários)
0.0