Drop downs

I have an excel worksheet which contains 3 seperate worksheets into one. I have managed to use the drop down function on the main worksheet from data used on the second worksheet, I am having trouble with the next part though. For example the main worksheet is a timesheet , in the second worksheet I have data which has all the job numbers, I have used the Insert, Name, Define etc etc and validate cells to produce the drop down on the main worksheet, this is fine. There are certain jobs which have 4 to 8 different codes to go with the job number. What I am trying to do is link the data from worksheet 2(job numbers) which produces a drop down to the different codes(worksheet 3) on another drop down after being selected from the first drop down.

Confused, so am I. Don't know if this can actually be done but would be grateful if someone could shed some light.

You could use dependent dropdown lists. There are instructions he

http://www.contextures.com/xlDataVal02.html

Neil R wrote:
I have an excel worksheet which contains 3 seperate worksheets into one. I have managed to use the drop down function on the main worksheet from data used on the second worksheet, I am having trouble with the next part though. For example the main worksheet is a timesheet , in the second worksheet I have data which has all the job numbers, I have used the Insert, Name, Define etc etc and validate cells to produce the drop down on the main worksheet, this is fine. There are certain jobs which have 4 to 8 different codes to go with the job number. What I am trying to do is link the data from worksheet 2(job numbers) which produces a drop down to the different codes(worksheet 3) on another drop down after being selected from the first drop down.

Confused, so am I. Don't know if this can actually be done but would be grateful if someone could shed some light.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Sounds like Debra Dalgleish's site would assist.

How to create dependent lists using DV

http://www.contextures.on.ca/xlDataVal02.html



On Tue, 15 Jun 2004 13:30:01 -0700, Neil R
wrote:

I have an excel worksheet which contains 3 seperate worksheets into one. I have managed to use the drop down function on the main worksheet from data used on the second worksheet, I am having trouble with the next part though. For example the main worksheet is a timesheet , in the second worksheet I have data which has all the job numbers, I have used the Insert, Name, Define etc etc and validate cells to produce the drop down on the main worksheet, this is fine. There are certain jobs which have 4 to 8 different codes to go with the job number. What I am trying to do is link the data from worksheet 2(job numbers) which produces a drop down to the different codes(worksheet 3) on another drop down after being selected from the first drop down.

Confused, so am I. Don't know if this can actually be done but would be grateful if someone could shed some light.