Small Excel Macro Needed

This is a Macro to help us save time when doing a weekly schedule. Basically, all it needs to do is: when a scheduler enters the hours worked for a day (From-To), and then chooses the Attendant's Name (must be a drop down list), those 3 cells (From, To and Attendant) will be painted into a color that will be unique that that Attendant

Name. And then it should calculate the total hours scheduled for the week for this attendant, into the table on the side. This will all make sense once you take a look at the attached excel file. The Attendant Names should come from a drop down list, which should be easy to edit, add and delete the names from... something similar to what I show in the file... very straight forward... In the example I highlight only few names, but the Macro needs to have a unique color for each name...

Thank you.

Skills: Excel

See more: excel macro needed, excel help needed, what is macro in excel, save to excel, macro, macro excel, macro + excel, excel us, excel table, attendant, edit macro, excel macro add, scheduler list, excel unique, 2011 excel add, time scheduler, file name excel, add excel macro, look table excel, add edit delete table, save table file, edit macro excel, excel edit, excel macro save, excel drop

About the Employer:
( 4 reviews ) Walnut Creek, United States

Project ID: #1144649

Awarded to:


Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement.

$30 USD in 0 days
(25 Reviews)

10 freelancers are bidding on average $55 for this job


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

$80 USD in 2 days
(65 Reviews)

Hi I am good in Excel and VBA Programming in Excel. I am interested to work for your project. I have experience in doing similar projects. Please refer my PM. Thanks Fibin

$30 USD in 1 day
(47 Reviews)

Please check your PMB

$60 USD in 1 day
(21 Reviews)

Please see PM!

$30 USD in 1 day
(27 Reviews)

Hi, please check your PM. Thank you.

$79 USD in 5 days
(22 Reviews)

For your consideration.

$30 USD in 1 day
(1 Review)

Please see PM

$100 USD in 2 days
(0 Reviews)

Looks like fun. Would be glad to take this on!

$80 USD in 1 day
(0 Reviews)

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 More

$100 USD in 3 days
(0 Reviews)

Hi, I can complete the task on the same day. Im expert in excel VBA.

$30 USD in 0 days
(0 Reviews)