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?

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?

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?

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?