Create 2 Dependent List.
Hello,
I am trying to create a dependent list of dependent list.
Ex:
First List Dependent List 2 Dependent List
Movies English Action
Hindi Romance
Let say if i select Movies then English it should list second dependent list based on first dependent list.
can it be possible.
Last edited by hecgroups; 01-27-2012 at 03:58 AM.
Hi
If i get your point, the answer is YES. We can do dependent list based on first dependent list.
To be clear fo ell. pls upload a sample workbook.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Thanks for reply,
Sample list is attached.
I have to make difference selection depending on my original data. If i get idea the i can do so.
So, the requirement is if select providers then signed. The 2nd dependent list should display the items in columns C ad drop down list.
..You mean that if the user select in B2, the word "Signed", then in B2,you want to appear the list that you have now in Column C?? Or you want this list In C2?
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
i want to select Providers fin A2 then i will select Signed or not signed or followup in B2 then depending on B2 list i will select C2 items which is Central, Eastern, etc... then so on....
If you get me the second dependent list i will study and make the list as i want.
...Why don't you use INDIRECT, as in B2??
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Got the idea. It means i can create the list under list and named as i want the use indirect function.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks