dependent dropdown boxes
Hi all, TIA..
I've made dependent boxes before but this one is a little trickier. I have a list of about 3500 entries that i'd like to utilize on a seperate sheet as a requisition form. To help the user I'd like them to be able to choose a number assigned to each group then in the second dropdown (now filtered from the first) choose a part number from that group and finally i have a VLOOKUP searching the part number to give its' description. The list is set up like this: Group Part # Description 1 100210 lined paper 1 100231 stapes 2 100456 blank cd's 2 2 2 3 3 3 3 3 and so on. the groups range from 2 to 47 Hope this is clear enough and again, thanks. Kevin M |
All times are GMT +1. The time now is 02:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com