Progressively filter a sheet using buttons and vba

**nobby2193** · 07-05-2013, 02:01 PM

Hi All
This is probably so simple to do and I feel I could do it in Access, but I'm forced to do it in excel which I struggle with

I have a list of printer makes and printer models that I want to filter down to enable the user to see the cartridge type etc.
So, in Access the user would type the printer make in a field that would start to give him the printer make i.e. BRO would populate BROTHER in the list, a filter would then be applied that would restrict the printer models to those provided by BROTHER ONLY.
In the next field the user would start to type DCP and DCP9010 would be populated and finally I would have a filtered list with the cartridge numbers etc. for a BROTHER DCP9010 showing me the colours etc.
I'm happy to accept any format that does the job and looks user friendly.
I also feel its about time I learned more about Excel

Many thanks
Nobby

**Palmetto** · 07-05-2013, 09:10 PM

Hi and welcome to the forum.

Take a look at using Dependent Validation Lists.

There is some work involved to set up the list, but it does not require any VBA code or controls.

I also suggest you make a visit to Jerry Beacaire's website and consider his AutoCompleteDataValidation(Sortof) series of examples.

Also recommended: a visit to YouTube for video demos and tutorial on nearly every Excel topic.
Seeing that you are using Excel 2007, I strongly advise the use of Excel Tables for your lists. Tables are automatically treated as dynamic ranges and will expand and contract as data are added/deleted. You may use Tables with Data Validation.

**nobby2193** · 07-09-2013, 04:47 AM

Hi
Thanks for your reply.
My dream was to have a working access style filtering database on my ipad, however, again, thank you apple for making life so much harder than it needs to be.
Thanks for your input but I have now dropped the project

Best Regards
Rob