Results 1 to 10 of 10

Display realtime filtering data from another worksheet

Threaded View

  1. 01-01-2019, 03:55 AM #1
    sokunthaneth
    sokunthaneth is offline
    Registered User
    Join Date
    11-25-2018
    Location
    Phnom Penh
    MS-Off Ver
    2016
    Posts
    4

    Display realtime filtering data from another worksheet

    I want to display all rows that has Gender column equal to `M` inside `sheet2`. The data is retrieved from `sheet1`. The filtered data also has to be real time, meaning whenever I make change in gender column in `sheet1`, `sheet2` data should also change accordingly. How could I achieve this?

    sheet 1
    sheet1.PNG

    sheet 2
    sheet2.PNG
    Attached Files Attached Files
    Last edited by AliGW; 01-01-2019 at 04:08 AM. Reason: Irrelevant section of thread title removed.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiuser excel userform data can we store in access database on realtime with 4 or 5 user
    By sagar.rajula in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2013, 09:18 AM
  2. [VBA] Filtering Data from Excel worksheet
    By qiqinuinaifen128 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-14-2012, 12:04 PM
  3. MICROSOFT barcode control -changing the barcode image in realtime
    By artner0112 in forum Excel General
    Replies: 1
    Last Post: 12-18-2011, 12:32 PM
  4. How can I set Microsoft Excel to display the day by inputting the date?
    By alexbutterfield in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-21-2007, 12:37 PM
  5. [SOLVED] Microsoft Query editor opens but does not display in excel.
    By Fizzbear in forum Excel General
    Replies: 0
    Last Post: 02-23-2006, 04:50 PM
  6. [SOLVED] How do I display data in different worksheet in excel
    By Hedgelayer2 in forum Excel General
    Replies: 1
    Last Post: 02-12-2006, 11:40 PM
  7. Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet
    By Graham Jones in forum Excel General
    Replies: 1
    Last Post: 05-12-2005, 08:06 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1