Advanced Filter Excel 2010

[Tescatlipoca]

Hi All, I have created the attached spreadsheet. I got multiple macros, one thing I can't figure out is using the advanced filter I am filtering the data within the Interface tab. All filters work fine except the date range???

I am using the formula: =IF(C7="","",">="&C7) and =IF(C8="","","<="&C8) on cells J3 and K3 as criteria. When I run this I get an error, when I update the formula to =IF(C7="","","="&C7) just remove the greater operator and no formula in K3 or no end date selected it works fine. I am really not sure what is wrong.

Well system does not let me attach the spreadsheet due to it is being over 1MB, I would really appreciate any help.

Regards,

[Bernie Deitrick]

Cut out all but a few rows from your spreadsheet and re-attach. Not sure what you are trying to do - use a better explanation of what you want instead of what you tried, since what you tried doesn't work.

[Tescatlipoca]

Cut out all but a few rows from your spreadsheet and re-attach. Not sure what you are trying to do - use a better explanation of what you want instead of what you tried, since what you tried doesn't work.

Form.zip

Ok attached the zip file, removed bunch of data and pivot tables, so the macro will probably fail now no matter what. But all I want to do is to filter the data by the selected date.

Regards,

[Bernie Deitrick]

This shows how to use the advanced filter option in Excel, with the correct criteria range setup, and a macro to apply/clear the filters.

Form upload.xlsm

[Tescatlipoca]

This shows how to use the advanced filter option in Excel, with the correct criteria range setup, and a macro to apply/clear the filters.

Attachment 353942

Thank you for your help, it does work on the spreadsheet you sent however, when I apply the same to mine it does not. I will try to trouble shoot it and find what I am doing wrong.

[Bernie Deitrick]

Use the same formulas that I have, with the same structure. Change all the Date values in your database to actual dates rather than text which requires formatting the cells as dates and re-entering the values (with a new column, using formulas is easiest). And the date values in your filter entry cells need to be formatted and entered as dates as well.

Otherwise, you could set up a helper column of formulas to return True or False to allow filtering based on the text values.