Selective brands for customers

Hi.

I have 1 mastersheet and 1 sheet with all the customer names and their possibilities for the choice op products. For example Customer X can only order from the brands A and B. Customer Z can only order from the brands A,C,D. In the mastersheet all the products are listed and categorized in sheets with their brand name. Is there a macro that can make a new file for Customer X where only products for brand A and B shows and another file for the next customer and so on and so on.

Cheers,
Roy de Mooij

You could create a drop-down that populates based on specific criteria. Post your workbook, and someone will happily help you get into more detail.

Hi,

Thanks for your reply. I attached a workbook on this thread. There it will hopefully become clear with what i'm saying. I'm looking for something that can make a new file with all the products from brands accepted by the customer. Is that possible? You do not have to look at the header deleted. That is for something else.
If you need something else you can always ask me.

Cheers,
Roy de Mooij

BUMP - Hopefully someone can help you - I can't write macros on my work computer :/

* Can't open external files - new job new rules lol

too bad.... Thanks for helping!