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

 

[BenMiller]

Okay I registered at box.com

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

I posted a link to a file which should solve your problem. Did you take a look at it?

 

[data_entry_dude]

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

 

[Oeldere]

See my example in this (free dutch) link

http://www.mijnbestand.nl/share.php?key=AYLRI4JMLPUY

I used defined names (so do you) with the name Employee.

Then i used datavalidation in B13 (orange cell)

Then i used Vloopup to get the data.

You work with merged cells.

You get problems with that sooner or later.

I deleted the merged cells (C en D).

The cells in row 13 you can drag down.

Also the data-validation will be copied.

Do you have questions, on this item, just ask.

 

[data_entry_dude]

Thank you thank you thank you.

You have made my day, in fact you have made my week!

You are the best!

 

[BenMiller]

Hi.

 

[Oeldere]

@data_dude_entry

For future use, please post to whom you responding.