+ Reply to Thread
Results 1 to 6 of 6

Auto Filter Data from another sheet

  1. #1
    Registered User
    Join Date
    11-21-2019
    Location
    philippines
    MS-Off Ver
    2016
    Posts
    4

    Post Auto Filter Data from another sheet

    Hi,

    Is there any way to Filter data from Sheet 1 to Sheet 2.
    For example. in the attachment i have (EAS Sheet) and there is a format. i want to filter EAS no. A1 and it will will show the data
    thank you
    Last edited by angelpasaway09; 11-15-2020 at 06:09 PM.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Auto Filter Data from another sheet

    It's not clear what you want to achieve. Can you explain further

  3. #3
    Registered User
    Join Date
    11-21-2019
    Location
    philippines
    MS-Off Ver
    2016
    Posts
    4

    Re: Auto Filter Data from another sheet

    Example sir. In the attachment i would like to filter a certain value form example. in the (EAS Form) sheet i want to filter the EAS No. A1 and it will fill the A1 Data.. i attached the example form i want to use thank you

  4. #4
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Auto Filter Data from another sheet

    So you want to enter a value in I1 and then all the "Get" values should be populated from the corresponding multiple rows in sheet1, correct.

  5. #5
    Registered User
    Join Date
    11-21-2019
    Location
    philippines
    MS-Off Ver
    2016
    Posts
    4

    Re: Auto Filter Data from another sheet

    yes exactly sir

  6. #6
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Auto Filter Data from another sheet

    Place this code on the EAS sheet Module

    Please Login or Register  to view this content.
    And place this code in any module

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy Data from current sheet with Auto Filter/Looping then paste to another sheet
    By stepkwan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2020, 09:04 AM
  2. Auto Filter Data & extract to another sheet
    By will2k in forum Excel General
    Replies: 2
    Last Post: 06-14-2016, 12:31 AM
  3. linking data validation to auto filter in other sheet
    By alexcrofut in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2014, 12:22 PM
  4. [SOLVED] Auto Populate cell based on auto filter selection from table in same sheet
    By missydanni in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-02-2013, 05:03 PM
  5. Auto filter on a protected sheet
    By robert.begley1 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 11-27-2012, 06:24 PM
  6. Auto filter to another sheet
    By HIHATIM in forum Excel General
    Replies: 1
    Last Post: 05-09-2012, 03:08 AM
  7. Auto Filter and sheet protection
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2008, 10:47 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1