Filter Data with a userform that has multiple criteria

[TubbzUK]

Hi,

i have a worksheet with loads of data on that i want to filter by several different options so there can be various different variations of filter.

i have attacehd a copy of the database with a userform created that i am trying to use.
this includes a date range, a week range and then 4 variables to filter by so 6 variables in total

i managed to do this with access but not sure how to go about this with excel.

The aim is that once the data is filtered the graphs will dynamically update with the filtered selection.

I am not very good at explaining things so if i am not clear please ask.

Any help is greatly appreciated

[Sean Thomas]

Hi TubbzUK,
couple of questions.

Where are your graphs? How many?
What data do you want represented in the graphs?
Do you want the filtered data copied to the Filter sheet?

If i get a chance i will have a look later today if nobody else comes up with a solution as this is a fair bit of work.

[Sean Thomas]

Okay,
first problem we have is all your dates are not actually dates.
Therefore the date filter will not work.
You will need to reslove this problem before we can filter them.

Ideally you need to have the data captured in date format, otherwise you will need to change the data to date format for the filter to work.

heres a link to show you how.

http://office.microsoft.com/en-gb/ex...001162867.aspx

I have changed the data you supplied but you will need to sort ths out first.

[TubbzUK]

Hi,

thanks for the help.

I think i understand the date issue.
i have got the filter for the week range to work and the single criteria. I just need to get them all workign at the same time so for example if you select team 1 and product F08228 then those will be the only results copied to the filter worksheet.

I have attached an updated version of what i have been working on today.

for the graphs and stuff i have not done them yet but what i was intending was a user form to show the grpahs that have been created from the filtered data. this will be dynamically created from the named ranges i create using offset on the filter sheet. i will probably create these tomorrow.

I also have to sort out the problem where once the apply filter button has been pressed the user form dissappears and loses focus. Gettign it back you have to alt tab it.

Thanks for your help. its greatly appreciated

[TubbzUK]

sorry, cant attach the file at the moment as for some reason it has jumped in size to 22mb!

the code i have put on the apply button is

Please Login or Register  to view this content.

Hope you can see what it does.

[Sean Thomas]

Hi,
I have updated the workbook.
run showform macro to open useform.
the comboboxes will be populated with unique values to select from.
I have added a couple of buttons which will display a date picker to choose your dates from.
Exit button dealt with, Clear selection done & enter button.

I haven't done anything with the charts as I don't know what you want to achieve.