santosonit
08-07-2019, 06:07 AM
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:
Remove filters on Sheet1, if any;
Filter based on those criteria;
Copy;
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.
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:
Remove filters on Sheet1, if any;
Filter based on those criteria;
Copy;
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.