Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Filling In Corresponding Data from Another Worksheet
Here's my situation:
I have a list of employees on on one worksheet. In the cells next to each employee name are their hourly pay rate, their department, and their various overtime thresholds (the elapsed hour they go in to overtime varies by employee). On a second worksheet, I've created a drop-down list for the employee names. I want their pay rate to follow the name, and appear in the cell next to the name. Currently, Excel 2003 is telling me that only delimited files are allowed to do that. Is there a way for the corresponding pay and overtime fields to migrate with the employee's name from the drop-down list? Thanks! ~Rip |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Filling In Corresponding Data from Another Worksheet
Very easily, using Vlookup.
Check out instructions here at Debra Dalgleish's web site at: http://www.contextures.com/xlFunctions02.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- wrote in message ups.com... Here's my situation: I have a list of employees on on one worksheet. In the cells next to each employee name are their hourly pay rate, their department, and their various overtime thresholds (the elapsed hour they go in to overtime varies by employee). On a second worksheet, I've created a drop-down list for the employee names. I want their pay rate to follow the name, and appear in the cell next to the name. Currently, Excel 2003 is telling me that only delimited files are allowed to do that. Is there a way for the corresponding pay and overtime fields to migrate with the employee's name from the drop-down list? Thanks! ~Rip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically copy data from one worksheet to another | Excel Worksheet Functions | |||
Look up Data from Worksheet within same Workbook | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
AUTOMATICALLY ENTER DATA FROM ONE WORKSHEET TO ANOTHER | Excel Worksheet Functions |