+ Reply to Thread
Results 1 to 3 of 3

Use two tables on separate tabs so that filtering one, filters the other

  1. #1
    Registered User
    Join Date
    12-21-2020
    Location
    Orange County
    MS-Off Ver
    California
    Posts
    3

    Use two tables on separate tabs so that filtering one, filters the other

    So I created a simple relationship between two tables on two separate tabs. I uploaded it as "Example". Anyway, what I want to do is if I Filter by Company1 (as an example) in the Summary tab, I'd like it to also filter by Company1 in Detail tab. I plan to set this up as "1" to "many" so that the Company names on the Summary will all be unique, but the Company employees will be more than one. The tables are named the same as the tabs. How do I do this?
    Attached Files Attached Files

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    11,943

    Re: Use two tables on separate tabs so that filtering one, filters the other

    AFAIK September has 30 days, not 31
    sandy
    Learn Power Query (XL2010/2013 require PQ add-in)
    I want to see what you are trying to achieve, not how you are trying to do it
    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    12-21-2020
    Location
    Orange County
    MS-Off Ver
    California
    Posts
    3

    Re: Use two tables on separate tabs so that filtering one, filters the other

    Any one have a suggestion?

+ 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. [SOLVED] In Lieu of Filtering/Pivot Tables, What Formula Can Replicate Filtering?
    By advertaddy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-22-2022, 09:18 PM
  2. Multiple Pivot Tables Separate Tabs, Update to Include New Month
    By TracyCurrent4 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-20-2021, 04:52 PM
  3. Filtering Slicers with Slicers ... with Slicers?
    By BOTJ33F in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-11-2019, 04:50 PM
  4. Replies: 1
    Last Post: 11-26-2015, 12:42 AM
  5. Moving multiple excel tabs into separate tabs/separate files
    By RO24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-02-2014, 11:04 AM
  6. Data Filters, tables and tabs
    By beanily in forum Excel General
    Replies: 1
    Last Post: 10-31-2012, 11:03 AM
  7. Pivot tables - Multiple filters across 2 tables
    By shoesterix in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2011, 05:02 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