ExcelEndeavor
New Member
- Joined
- Oct 13, 2020
- Messages
- 34
- Office Version
- 365
- Platform
- MacOS
I have a userform that I use to track budget items. The screenshot below shows a blank form that is used to enter in the information, as well as edit existing info. Invoices are entered and submitted through another userform that pops up when the user clicks "Add Invoice" and submits from there. Those details are sent to a worksheet called "PO Data" along with 3 fields from the userform below -
Team Lead (column A)
Business Unit (column B)
Payee (column C)
I would like to search the worksheet "PO Data" (columns A:C) for any matches across those 3 fields and return the invoice results (columns E:H) back to the listbox highlighted in red.
For example, any maches where Stacy from the Sales Dept with a PO from vendor Adobe, I would like the invoice details to show in the listbox in real time.
It would make more sense to just search for the PO number, but some vendors don't issue a PO - they just use our corp credit card on file, so there are several "cc" instances in the PO number column.
How would I accomplish the search, match, and return ?
Team Lead (column A)
Business Unit (column B)
Payee (column C)
I would like to search the worksheet "PO Data" (columns A:C) for any matches across those 3 fields and return the invoice results (columns E:H) back to the listbox highlighted in red.
For example, any maches where Stacy from the Sales Dept with a PO from vendor Adobe, I would like the invoice details to show in the listbox in real time.
It would make more sense to just search for the PO number, but some vendors don't issue a PO - they just use our corp credit card on file, so there are several "cc" instances in the PO number column.
How would I accomplish the search, match, and return ?