Good day People,

I hope you are well, I stumbled on this forum trying to find a solution to a problem I am having. I am not a VB coder at all but I need to develop a dashboard in Excel that meets the following requirements;

1. On Sheet 1, there should be a list of tick boxes, such as Cows, Chickens, Pigs.
2. On Sheet 2,3,4 onwards, I have a list of customers that buys Cows,Sheep, Chickens etc from us, So Column A - Name, Column B -Phone number. So in other words Sheet two is called Cows, Sheet 3 is called Sheep and so forth.
3. Sheet one is what I need help on. I need to be able to tick some of the boxes and return on sheet 1 the customers who buy sheep, cows, chickens etc according to which boxes were ticked. A button should activate this Macro. So if Chickens and Cows are ticked, it should only return customers which buys both chickens and cows.

Please can you guys help me with this, I have been trying for a while with no luck, as I mention Im not a VB coder so I have little knowledge on it.


Thank you Kindly

Oren