Computing.Net > Forums > Office Software > linking combos in Excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

linking combos in Excel

Reply to Message Icon

Name: danielbenedykt
Date: June 29, 2004 at 10:48:17 Pacific
OS: Win XP
CPU/Ram: Pentium 1.6/512
Comment:

I have two lists
Categories and Subcategories
The first list is like this
idcat-descripcion
1-cat1
2-cat2
......
The second list
idsubcat-description-idcat
1-subcat1 -1 (from category 1)
2-subcat2 -1 (from category 1)
3-subcat3 -2 (from category 2)

I want to have two combo boxes (or it may be using data validation) that when I select one category, on the second combo shows the subcategories that correspond to that category
example:
If I select "cat1" on the first combo, it should show only subcat1 and subcat2 on the second combo

Thanks


---------------
Daniel Benedykt



Sponsored Link
Ads by Google

Response Number 1
Name: charlie1130s
Date: June 30, 2004 at 06:31:19 Pacific
Reply:

You could always do an IF statement in the area where you are pulling the Validation from. =IF(A1=F2,"Sub1","Sub10")
Hope this helps


0
Reply to Message Icon

Related Posts

See More


Office XP - network insta... Endless Select in Excel X...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: linking combos in Excel

Linking two combo boxes in Excel www.computing.net/answers/office/linking-two-combo-boxes-in-excel/2900.html

Print button in excel www.computing.net/answers/office/print-button-in-excel/8213.html

Mystery email address link in excel www.computing.net/answers/office/mystery-email-address-link-in-excel/8344.html