Using VBA to AutoFilter Multiple Criteria

[k9care]

Hi all,

I am learning about VBA and Macros and am currently struggling with a project. I am sure that it is a simple solution but after days of struggling I have decided to ask for help.

Attached is a small spreadsheet with 3 Worksheets - Lists, Data and Interface. I have named the ranges and linked the pages and even managed to write some VBA Code to get the Filter Button and Clear Buttons to work.

I would like for the Filter Button (when clicked) to sort for Invoices between two dates which seems to work ok. I can even filter by invoice number. But alas, the Customer and Product Name filters are just not working and I cannot find the problem. PLEASE could someone help me get this filter to work, so that it can filter not only between the dates but also by Customer, Product Name and Invoice Number respectively??

I would be so extremely grateful for any help

[venkat1926]

not clear what you want. can you use PIVOT TABLE. see attached field . data is sheet "data". see sheet "pivot table"

[k9care]

Thank you for your reply Venkat,

If you have a look at the Interface worksheet - I would like to be able to enter the Start Date (C6), Finish Date (D6), Customer (E6), Invoice Number (F6) and/or Product Name (G6) and then click on the "Filter Data" button so that a VBA macro can automatically filter the
data into the range C8:I8 below.

The date filter and invoice number filter seems to be working, but not the Product Name or Customer filters. I think it might have something to do with the coding of the macro "Filterme", but have no idea how to fix it. Any ideas?