| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Sheet list linkage
I am in the process of developing a Time & Materials daily time sheet, with
variables being name, position, hours (straight & Overtime) and rates. I would somehow like to link specific rates (straight & overtime) to specific positions, with positions in a drop down list. Is there any way to do that? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Sheet list linkage
Yes, there is.
Go to the Data menu, select data validation, select list as your criteria and enter the range of your list. Dave Brevity is the soul of wit. "ELN" wrote: I am in the process of developing a Time & Materials daily time sheet, with variables being name, position, hours (straight & Overtime) and rates. I would somehow like to link specific rates (straight & overtime) to specific positions, with positions in a drop down list. Is there any way to do that? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Sheet list linkage
This solution does not seem to work for the kind of relationship I have to
have. Is there a way to send an example? "Dave F" wrote in message ... Yes, there is. Go to the Data menu, select data validation, select list as your criteria and enter the range of your list. Dave Brevity is the soul of wit. "ELN" wrote: I am in the process of developing a Time & Materials daily time sheet, with variables being name, position, hours (straight & Overtime) and rates. I would somehow like to link specific rates (straight & overtime) to specific positions, with positions in a drop down list. Is there any way to do that? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Sheet list linkage
This solution does not seem to work for the kind of relationship I have to
have. Is there a way to send an example? "Dave F" wrote in message ... Yes, there is. Go to the Data menu, select data validation, select list as your criteria and enter the range of your list. Dave Brevity is the soul of wit. "ELN" wrote: I am in the process of developing a Time & Materials daily time sheet, with variables being name, position, hours (straight & Overtime) and rates. I would somehow like to link specific rates (straight & overtime) to specific positions, with positions in a drop down list. Is there any way to do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data from two sheets make up real time list in the new sheet?? | Excel Worksheet Functions | |||
| Data from two sheets make up a list in a third sheet (real time) | Excel Worksheet Functions | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Finding and compiling list of cells containing data... | Excel Worksheet Functions | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
Linear Mode
