Consulting

Results 1 to 2 of 2

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

  1. #1
    VBAX Regular
    Joined
    Aug 2019
    Location
    Fortaleza
    Posts
    11
    Location

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

    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.

  2. #2
    VBAX Expert
    Joined
    Sep 2016
    Posts
    763
    Location
    >using below code

    ???

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •