In Progress

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, save excel, macro, macro excel, excel us, 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, excel list example, edit excel, macro calculate

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

Project ID: #1144649

Awarded to:

vgrichards

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)
4.1

10 freelancers are bidding on average $55 for this job

bharanisrihari

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

$80 USD in 2 days
(65 Reviews)
6.4
FIBIN

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)
5.4
Krusche

Please check your PMB

$60 USD in 1 day
(21 Reviews)
5.2
imudita

Please see PM!

$30 USD in 1 day
(27 Reviews)
4.7
telemarketing555

Hi, please check your PM. Thank you.

$79 USD in 5 days
(22 Reviews)
4.4
kanadyanako

For your consideration.

$30 USD in 1 day
(1 Review)
1.8
Steponitgal

Please see PM

$100 USD in 2 days
(0 Reviews)
2.0
JaneGeisel

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

$80 USD in 1 day
(0 Reviews)
0.0
goal67

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)
0.0
smenedi

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

$30 USD in 0 days
(0 Reviews)
0.0