+ Reply to Thread
Results 1 to 2 of 2

Multi-Filtering applied to Form

  1. #1
    Registered User
    Join Date
    04-16-2019
    Location
    Phoenix, AZ
    MS-Off Ver
    O365
    Posts
    6

    Multi-Filtering applied to Form

    Hello All,

    Sheet 1: Form
    • Lists: Type1, Type2, Type3
    • Columns: Name, Date
    • Fill Ins: Address, FromDate, ToDate

    Sheet 2: Raw Data
    • Columns: Name, Date, Address, Type

    What I am attempting to do is populate the 3 lists on the Form using the Fill Ins to filter the data.
    Also the 3 lists need to get that filtered data but only show the appropriate Types.
    This form is sized specifically for one page, I am unsure how to go about populating the data into the lists.

    So List Type 1 would show all the rows that are filtered by the Type, Address, Date between FromDate and ToDate.
    Likewise for the other 2 lists.

  2. #2
    Registered User
    Join Date
    04-16-2019
    Location
    Phoenix, AZ
    MS-Off Ver
    O365
    Posts
    6

    Re: Multi-Filtering applied to Form

    I ended up figuring it out. =)

    I used a Power Query on Table(s).

    Filters
    Address: Made it a 1 field Table and did a query returning first item result and made it a connection only.
    FromDate: Made it a 1 field Table and did a query returning first item result and made it a connection only.
    ToDate: Made it a 1 field Table and did a query returning first item result and made it a connection only.

    Raw Data
    Created a tab and it has 3 tables all with the exact queries applied to each, only modification is the Type which I applied in the query window.

    Here is where I got the basics of how to perform what I needed, I had to modify it to serve my purpose, but it got me there. =)
    As I am unable to post links search YouTube for:
    Power Query with Input Variables from Excel Sheet to Extract Records

+ 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. Checklist and/or Multi Filtering
    By danallamas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2015, 11:12 PM
  2. Filtering while group function is applied
    By yttgle in forum Excel General
    Replies: 0
    Last Post: 08-15-2014, 03:08 AM
  3. Multi-Worksheet results needed with Rules applied
    By vortexkid in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-21-2012, 08:22 PM
  4. Filtering Form Criteria and Searching Main Form
    By gatorator in forum Access Tables & Databases
    Replies: 3
    Last Post: 04-06-2011, 07:48 AM
  5. Replies: 6
    Last Post: 12-09-2010, 01:32 PM
  6. Multi-Column Filtering
    By shotsy247 in forum Excel General
    Replies: 2
    Last Post: 04-27-2010, 09:12 AM
  7. [SOLVED] form code applied to sheet
    By David in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2006, 05:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1