PLEASE help me with a VBA macro to filter data with mutiple criteria

[dlpessleo]

I am learning about VBA and Macros and am currently struggling with a small project. I am sure that it is a simple solution but after days of struggling, I have decided to ask for help. I have a small spreadsheet with 3 Worksheets (Interface, Data & Lists) I have named the ranges on the Lists sheet and linked the sheets and even managed to write some VBA Code to get the Filter Data and Clear buttons to work.


What I have been trying to achieve is this:


If you 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 Product Name (G6) in the respective cells and then click on the "Filter Data" button so that a VBA Macro can automatically filter the date into the range C8:I8 below.


The date filter and invoice number filter seems to be working with the "Filterme" macro, but not the Product Name or Customer filters. I think it might have something to do with the coding of the "Filterme" macro or something else I might have missed. I have been pulling my hair out trying to find the problem and after days of struggling I have decided to ask for help.


I cannot move forward with this project until I get the filters sorted. Any help would be greatly appreciated...