If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Drop downs
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 |
#3
|
|||
|
|||
Drop downs
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. |
Thread Tools | |
Display Modes | |
|
|