Multiple Cell Selection using drop-down

[data_entry_dude]

HELP ME PLEASE!

My database is simple (employee name, category, hourly rate, overtime rate, reg hours worked, overtime hours worked).

My problem is the employee list is huge and they all have different categories.

I have the employee list set-up as a drop-down. I want to be able to drop-down the category and link the hourly rate and overtime rate to it. If I select a Category I want the rates for that category to auto-fill so all I have to do is enter their hours. I know this is possible, I just don't know how. Here's what my workbook looks like if it helps:

Employee Name Category Hourly Rate Overtime Rate Reg Hours O.T. Hours Total
John Johnson Labourer $40 $60 8 4 $560



I hope someone out there can help because I'm falling behind at work and I'm screwing up the rates for some people.


Thank you

 

[Oeldere]

I think you're looking for the links below.

Create multiple linked dropdown list in excel<o></o>
http://helpdeskgeek.com/office-tips/create-multiple-linked-dropdown-lists-in-excel/<o></o>
http://thefinch.wordpress.com/2008/02/09/excel-dynamische-afhankelijke-datavalidatie/<o></o>
http://www.contextures.com/xlDataVal02.html<o></o>
http://www.snb-vba.eu/VBA_Afhankelijke_validatie.html also in Englisch<o></o>

 

[data_entry_dude]

I tried all of the links you supllied, but they don't refer to my situation.

If I select a category, is there a way to connect each category with its appropriate rates? EG: A Construction Foreman's rate is $70/hr. and a Labourers rate is $40/hr. When I pick Construction Foreman from the drop-down list is there a way the $70/hr will automatically be entered?


Please help.

 

[Oeldere]

Maybe you can post an example of your sheet, without confidentional information on a free site.

Maybe (e.g.) this free dutch site.

http://www.mijnbestand.nl/

 

[data_entry_dude]

I don't understand dutch. Can you do remote assistance?

 

[data_entry_dude]

Or can I e-mail it to you?

 

[BenMiller]

Try www.box.com. It sounds like you need a simple VLOOKUP though.

 

[BenMiller]

Does this help you?

https://www.box.com/s/e2f54de6c285bc7abdf0

 

[data_entry_dude]

Okay I registered at box.com

So is there a way for you to look at it?

 

[Oeldere]

Can you post a link to your file, so we can download it.