Hello there,
I've been trying to solve this one, but no success so far.
I got:

Sheet1, containing:
Date Salesman Total

Sheet2, containing:
Cell B6 with Criteria1: StartDate
Cell B7 with Criteria2: EndDate
Cell b5 with Criteria1: SalesMan

Then, a table to receive the data filtered underneath those criteria fields.

I understand I have to:
  1. Remove filters on Sheet1, if any;
  2. Filter based on those criteria;
  3. Copy;
  4. Paste;


Steps 3 and 4 are the ones giving me a headache, as I can't find a way to autofilter only the columns that I want and paste them on Sheet2. When I do it, using below code, I got all of the columns from Sheet1.

Any help is greatly appreciated.