Populating Specific Lists Based on Criteria
 

I'm creating a timesheet form and want to be able to populate a list of job
codes specifically by client.
For example, in the Client Column you select Client X from a list. The Job
Code Column would then produce the drop down list specifically related
to Client X. If in the Client Column I selected Client Y, the Job Code
Column would then produce the specific job codes related to Client Y.

There may be a much simpler alternative- any help would be appreciated.

Populating Specific Lists Based on Criteria
 

Hi Kate

Maybe you want to use this
http://www.contextures.com/xlDataVal02.html

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kate" wrote in message ...
I'm creating a timesheet form and want to be able to populate a list of job
codes specifically by client.
For example, in the Client Column you select Client X from a list. The Job
Code Column would then produce the drop down list specifically related
to Client X. If in the Client Column I selected Client Y, the Job Code
Column would then produce the specific job codes related to Client Y.

There may be a much simpler alternative- any help would be appreciated.

Populating Specific Lists Based on Criteria
 

Thank You!

"Ron de Bruin" wrote:

Hi Kate

Maybe you want to use this
http://www.contextures.com/xlDataVal02.html

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kate" wrote in message ...
I'm creating a timesheet form and want to be able to populate a list of job
codes specifically by client.
For example, in the Client Column you select Client X from a list. The Job
Code Column would then produce the drop down list specifically related
to Client X. If in the Client Column I selected Client Y, the Job Code
Column would then produce the specific job codes related to Client Y.

There may be a much simpler alternative- any help would be appreciated.