I have a spreadsheet that I have designed to help me track incoming invoices so that I don't pay the same one twice if it gets sent in again. It runs off a list that includes the vendors name, the invoice number, amount and so on. The invoice numbers are unique, but obviously each vendor is in there multiple times.
I have created a VBA interface page. A combobox on this page has the vendor list as it's source. I have a listbox that I need to link to it in such a way that when I select a specific vendor, the listbox populates with the invoice numbers from that vendor and that vendor only.
Any ideas on how to do this?
Thanks,
Scott
Bookmarks