drop_down_box
hey guy, got a question! i got six main types of repair and under the six main categories, there are ten sub categories. now, i want to create a drop down box that will show the sub categories of the categories once the main category has been chosen the scenario: group1 group 2 group3 aaa eee iii bbb fff jjj ccc ggg kkk ddd hhh lll so in the drop down box, once group 1 is chosen, in the next column, only aaa,bbb....ddd can be chosen. can INDIRECT() solved the problem? IF so , how to solve it? -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=467437 |
See http://www.contextures.com/xlDataVal13.html#Depend
-- HTH Bob Phillips "cjjoo" wrote in message ... hey guy, got a question! i got six main types of repair and under the six main categories, there are ten sub categories. now, i want to create a drop down box that will show the sub categories of the categories once the main category has been chosen the scenario: group1 group 2 group3 aaa eee iii bbb fff jjj ccc ggg kkk ddd hhh lll so in the drop down box, once group 1 is chosen, in the next column, only aaa,bbb....ddd can be chosen. can INDIRECT() solved the problem? IF so , how to solve it? -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=467437 |
All times are GMT +1. The time now is 05:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com