Filter Data Based on Dates + other criteria & copy to another sheet

[santosonit]

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.

[mana]

>using below code

???