Hi,

I am new to VBA programming for Excel, and I would like to ask for some help on my filtering macro.

I have a sheet called Raw Data. The sheet has 6463 rows and 69 columns. One column has an ID category (text), one column has a type (text), one column has location (text) and one column had date and time, for example 5/23/2013 8:30:00 AM. The sheet is created by a macro that was written by someone else before my time.

I need to use this Raw Data to create a sheet with data filtered according to what the user selects via a drop down menu on a new sheet called Filtered Data. I have taken the column headings from the Raw Data sheet and created a drop down menu using these headings. I wish I could put them in alphabetical order but I am not sure how to do that via a macro, but that is less pressing at this time.

What I need to do is select the filter type via the drop down menu and extract the information from the Raw Data sheet that meets the filter criteria onto the Filtered Data sheet. For the numerical (number or percentage) data I need to extract data less than or equal a max value and greater than or equal a min value. For example data in column Z <= 10 and >= 3.4. For the text data I need to extract text that meets the text selected in the drop down menu. In all cases I need to also copy over the row information I columns B and C and BN. Column A is always blank.

Here is an example of the Raw Data (I have cut down the number of columns):

Col A Col B Col C Col D Col E Col F Col G Col H Col I Col J
A HC MLR USA 14386 13.28 1.16% 41.52 5/13/2013 4:30:00 PM

If I filter based on Col C then I want all data that match the text selected from col C plus col A, B and I.
Ihope I have described this sufficiently. Any advice and help would be greatly appreciated. Thank you.