I have a two sheet workbook, sheet two containing a database saved in a table (exported from Access) and sheet one being my form that auto-populates most of the cells via a drop-down data validation list from the first column of the table.
See previous post :
http://www.mrexcel.com/forum/excel-questions/718097-nest-vlookup-isblank.html#post3538302
The drop-down contains approximately 1,000 items, referencing records in the table, each in a numeric format 1234/123, of which there are around 15 unique pre-fix's, (1234)
As this is quite unwieldly in an 8 row drop-down, ideally I would like to place another drop-down at the top of my form sheet containing the 15 unique four figure prefix's that would then filter the previous drop down to show only the 65 records with the same prefix.
I have found a method here:
Shorten Data Validation List With Excel Filter Macro | Contextures Blog
but this seems far more complicated (?) than I need.
Can anyone suggest a simpler method of achieving this filter, bearing in mind that I need to circulate the workbook to others who are even less Exel literate than myself, so needs to be idiot proof !
Many Thanks
See previous post :
http://www.mrexcel.com/forum/excel-questions/718097-nest-vlookup-isblank.html#post3538302
The drop-down contains approximately 1,000 items, referencing records in the table, each in a numeric format 1234/123, of which there are around 15 unique pre-fix's, (1234)
As this is quite unwieldly in an 8 row drop-down, ideally I would like to place another drop-down at the top of my form sheet containing the 15 unique four figure prefix's that would then filter the previous drop down to show only the 65 records with the same prefix.
I have found a method here:
Shorten Data Validation List With Excel Filter Macro | Contextures Blog
but this seems far more complicated (?) than I need.
Can anyone suggest a simpler method of achieving this filter, bearing in mind that I need to circulate the workbook to others who are even less Exel literate than myself, so needs to be idiot proof !
Many Thanks