Sedang Disiapkan

Excel schedule template functionality

There are two different types of meeting, Yellow and Red

Atendees may attend up to two Red meetings and up to Three Yellow meetings

Not all attendees will have a full set of meetings

The meetings will be pre-populated with diffrent time slots for every location, and each time slot and location pair will have a unique Meeting_ID

The person who is scheduling the meetings will assign a Meeting_ID in each Meeting column in the Attendees sheet.

Requirements:

1) Create a custom function to pupulate the ATTENDEE_IDs column in the Yellow_Meetings and Red_Meetings sheets. This is the Attendee_ID of every attendee in that meeting, separated by commas

This formula must be able to be auto-filled down the column as new Attendees and Meetings are added. I.e. It muct not require manual modification when copying the formula/function to a new row

2) Create a report of all meetings (Yellow and Red) being attended by any given Attendee. This report will be the Attendees personal agenda and should include the time, date, location, subject, and description of every meeting for that attendee

The report should be filterable by Attende Name or ID number

The report should be printer-friendly and well formatted so that a presentable agenda can be printed out for any given attendee on request

Kemahiran: Excel

Lihat lebih lanjut: excel schedule template, excel scheduling template, excel template schedule attendees, excel red yellow, scheduling template functionality, template function, excel sheet formula, excel report, excel function, excel formula, template report, custom formula, excel row column, set printer, excel unique, excel column row, attendee, excel time sheet, excel custom number, time slot, formula sheet, excel formula description, excel number custom, column row excel, excel custom

Tentang Majikan:
( 2 ulasan ) London, United Kingdom

ID Projek: #1547694

Dianugerahkan kepada:

Nhcuong

Hi, VBA expert here for this bid. Please check the PMB for the file you need.

£10 GBP / jam
(20 Ulasan)
4.8

8 pekerja bebas membida secara purata £13/jam untuk pekerjaan ini

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

£15 GBP / jam
(58 Ulasan)
6.3
Krusche

We are a team of professionals developing Excel +VBA based applications. Assume high quality work with a precise attention to details. Check your PMB for examples.

£25 GBP / jam
(21 Ulasan)
5.2
chriskerpini

More than 10 years experience in Excel, VBA. Please check your PMB for details.

£10 GBP / jam
(12 Ulasan)
4.4
muthumuni

...........#####... "KINDLY FOLLOW MY MASSAGE & FEEL REAL DIFFERENT HERE" ...##### ............

£10 GBP / jam
(6 Ulasan)
3.5
richardst

Hello, Sir. How are you? I have over 10 years of Excel vba programming and over 6 years of Excel plugin programming using C#. In addition i have much experiences in other Office programming such as Word, Powerpoi Lagi

£10 GBP / jam
(0 Ulasan)
0.0
alliepalmer

Hello! I currently work in an industry with precious little IS budget, so I am constantly working on unique and creative ways to solve Excel problems. Writing formulas and creating attractive, printable formats tha Lagi

£10 GBP / jam
(0 Ulasan)
0.0
mlpraveena

Interested in your project

£15 GBP / jam
(0 Ulasan)
0.0