Hi, I'm new to the forum and hoping someone can help me.
I have two columns on sheet1, one named ProductCode and the other named Customer. There is a row for each time a customer has purchased a ProductCode.
On sheet5, I have created a combobox which drops down the list of products. I'm trying to make it so that when I select the productcode in the combobox, it returns a list of the customers who have bought that product.
So, based on the below table if i selected "Product1" I would like it to return "Customer" and "Customer2"
Customer Product1
Customer2 Product1
Customer3 Product2
I did VB years ago but i've forgotten even the basics! If someone could just point me int he right direction that would be most appreciated. a tempalte would be even more fantastic! Thanks in advance.
Bookmarks