+ Reply to Thread
Results 1 to 2 of 2

Autofilter rows based on column data in other sheet or file

  1. #1
    Registered User
    Join Date
    02-27-2014
    Location
    Lithuania, Klaipeda
    MS-Off Ver
    Excel 2013
    Posts
    94

    Autofilter rows based on column data in other sheet or file

    I would like to ask one question. I have two data tables. It has same connecting values. I would like to make auto filter, so that one table would show values based on values from another table. Also, would it be possible to apply this auto filter two different excel files?
    Example is attached. Thank you!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    108

    Re: Autofilter rows based on column data in other sheet or file

    Have you experimented with Advanced Filter?

+ 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. VBA to autofilter data based on set criteria into a new sheet
    By indik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-24-2015, 04:54 PM
  2. [SOLVED] extracting rows of data from on sheet to another based on Column A
    By sdehod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2014, 03:48 PM
  3. Move Rows of Data from a Specific Column (Based on Matching Criteria) to a new Sheet
    By jordan1214 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2013, 02:30 AM
  4. Replies: 3
    Last Post: 10-22-2012, 05:23 PM
  5. Copy rows into new sheet based on cell/column data
    By StagemanGraham in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2012, 08:11 PM
  6. Copying Rows to to another Sheet based on the column data?
    By BhuvanRam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2012, 12:56 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