PDA

View Full Version : Filter Data Based on Dates + other criteria & copy to another sheet



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.

mana
08-07-2019, 06:23 AM
>using below code

???