Filtering/Screening Data using Userform

[madrid1234]

Hi all,

I have a range of cross-sectional data, with a couple hundred rows and 10 or so columns. I would like to create a screener that filters this data according to criteria that are entered in a userform.

For example, I would like to filter the raw data for all entries that have a Column C entry between 10 and 30, and Column F entries between 1 and 5.

I already created a userform with the relevant drop-down boxes / textboxes. Any ideas on writing the VBA code to do the filtering?

I am attempting to record a macro in which I simply use the advanced filter manually, but I don't know how I would adjust the code so that the program filters according to any ranges the user specifies in the userform.

Thanks!

 

[James006]

Hi Madrid,

With regards to your problem, bear in mind the userform is only a user interface ...
As far as writing the VBA code, why don't you turn on the macro recorder and go through the process once ...
You will get the backbone of the VBA code ...

HTH

 

[madrid1234]

Thanks for your response James. The problem is that I don't know how to make the filtering dependent on the variables you enter in the userform. For example, let's say my data represents various cities around the world (rows) and their characteristics (columns), and let's assume I want to filter for all cities with average temperature between 10 and 20 degrees. If I record the process, I will have to pick some numbers for the temperature I want to filter. But eventually, I want the program to filter for cities with temperatures between any variables x and y that the user enters into the userform.

 

[James006]

Hi,

The process you are describing is the exact one ...
Just go ahead with the macro recorder ... and you will get your code written ...
Then, you will have to slightly adjust it, say for the temperatures by creating the variables the user will input ...
But all the "hard" work will already be done ...

HTH