+ Reply to Thread
Results 1 to 1 of 1

filtered range from 2 tables

  1. #1
    Forum Contributor
    Join Date
    04-05-2013
    Location
    CT
    MS-Off Ver
    Excel 2010
    Posts
    360

    filtered range from 2 tables

    I'm looking to create a userform that has a listbox that populates data from 2 separate tables.

    table 1 = project information
    table 2 = billing information per project by month

    the purpose of the userform is to view all billings per specified month for all ACTIVE projects. (then have the ability to modify the amount)...i really dont know what the best method is to do this but i will try to explain the basic functions that i believe would need to happen.

    1. generate a list of all ACTIVE projects from table 1
    2. search for billings in table 2 that match the specified month and year within the userform
    3. populate listbox.
    4. i would then like to be able to click on a line item within the list box and then modify the billing amount within the userform.

    i attached a sample of the 2 tables i have and a real basic userform with the fields i think i would need. I hope this make some sense, i'm trying to explain everything without getting to in depth.

    My initial thought was to start i need to have a filtered range for perform items 1 & 2 above...but not sure if you have do that with 2 tables? Any help is appreciated or if someone can point me in the right direction as to where to start i would appreciate that as well. Thanks!
    Attached Files Attached Files

+ 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. Printing one filtered result at a time with pivot tables
    By Leouw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2015, 05:12 PM
  2. How to query with multiple tables, filtered by value in 2nd table
    By Quiksilver3133 in forum Access Tables & Databases
    Replies: 1
    Last Post: 06-22-2015, 09:41 AM
  3. [SOLVED] Excel VBA - Issue in Naming Filtered Range on a Filtered List.
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2014, 01:17 PM
  4. Pivot Tables - Listing Filtered Labels
    By learning_vba in forum Excel General
    Replies: 0
    Last Post: 06-13-2011, 03:50 PM
  5. Naming cells in filtered tables
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2010, 02:15 PM
  6. Excel 2007 : Filtered lookups for chart tables
    By smudgepost in forum Excel General
    Replies: 0
    Last Post: 07-02-2010, 08:52 AM
  7. Replies: 0
    Last Post: 02-26-2009, 12:10 PM

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