Hey there, I'm an Excel newb and I've searched for my problem through the forum but unfortunately couldn't find any solutions. BTW I'd been using Excel in Turkish and recently bought an English version (Office 2007) so I kind of have difficulties to understand English names of menus and buttons, etc, so forgive my ignorance if there are actually related threads.
Anyway, here it goes:
I have to create a form for easy-calculation of technical service costs. In my "DATA" sheet I noted employee names and their hourly pay:
http://i.imgur.com/jrP7owF.jpg
I've selected employee names and called them "NAMES". Then I've managed to create a drop down list on my "CALC" sheet using Data Validation menu and this is the result:
http://i.imgur.com/9qCVw77.jpg
Now I want to link both tables. I will select any employee name and input hours in service so it will automatically calculate total cost and add profit margin to find service fee. Let's say it will look like this:
http://i.imgur.com/Ojkjdyd.jpg
I'm sure there's in fact an easy solution but once again, I'm an Excel newb. Thanks in advance!
Anyway, here it goes:
I have to create a form for easy-calculation of technical service costs. In my "DATA" sheet I noted employee names and their hourly pay:
http://i.imgur.com/jrP7owF.jpg
I've selected employee names and called them "NAMES". Then I've managed to create a drop down list on my "CALC" sheet using Data Validation menu and this is the result:
http://i.imgur.com/9qCVw77.jpg
Now I want to link both tables. I will select any employee name and input hours in service so it will automatically calculate total cost and add profit margin to find service fee. Let's say it will look like this:
http://i.imgur.com/Ojkjdyd.jpg
I'm sure there's in fact an easy solution but once again, I'm an Excel newb. Thanks in advance!
