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!
Bookmarks