Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula to connect cells in different worksheets?
How do i link an employee to their wage automatically? Is it possible to
enter in my employee's name and hours, and have it automatically calculate their wage? I have all my employees wages in another worksheet right now. At this time I go to my job record worksheet I enter in my employee, enter the hours type =left arrow tab to worksheet with wages and click on the employee then hit enter, this gives me there total wage. I am trying to see if I can program the name and wage together somehow, that when I do type the name it calculates with the hours and gives me a total. |
#2
|
|||
|
|||
tb
Use the VLOOKUP Function. Input sheet A1 you type the name(or use Data Validation drop-down list) Input sheet B1 you type the hours. Input sheet C1 has this formula =VLOOKUP(A1,wagesheet!$A$1:$B$20,2,FALSE)*B1 Now on wagesheet you have names in A1:A20 and wages in B1:B20 Gord Dibben Excel MVP On Wed, 2 Mar 2005 11:09:05 -0800, "tb" wrote: How do i link an employee to their wage automatically? Is it possible to enter in my employee's name and hours, and have it automatically calculate their wage? I have all my employees wages in another worksheet right now. At this time I go to my job record worksheet I enter in my employee, enter the hours type =left arrow tab to worksheet with wages and click on the employee then hit enter, this gives me there total wage. I am trying to see if I can program the name and wage together somehow, that when I do type the name it calculates with the hours and gives me a total. |
#3
|
|||
|
|||
Thank you for your help,it is just what I was looking for.
"tb" wrote: How do i link an employee to their wage automatically? Is it possible to enter in my employee's name and hours, and have it automatically calculate their wage? I have all my employees wages in another worksheet right now. At this time I go to my job record worksheet I enter in my employee, enter the hours type =left arrow tab to worksheet with wages and click on the employee then hit enter, this gives me there total wage. I am trying to see if I can program the name and wage together somehow, that when I do type the name it calculates with the hours and gives me a total. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you copy a cell's content verses it's formula? | Excel Discussion (Misc queries) | |||
My formula screws up other reference cells... | Excel Discussion (Misc queries) | |||
what allows me to select cells for use in a formula by using a mo. | Excel Worksheet Functions | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
sum of different cells in different worksheets??? | Excel Worksheet Functions |