Hi Excel Forum,

I work in logistics and would like to let the 4 countries I work for know when a product goes out of stock, or goes back in stock. Right now I have a file that automatically populates the information in each country's workbook; but if the product is taken by multiple countries, I have to rewrite that info in up to 4 columns (1 per country). I have an idea for utilizing check boxes, but am not quite sure how to execute this idea.

My idea is for check boxes to do the following:
1. Grey out when the country does not take the specific product
2. When the country's box is checked, it automatically send the relevant information to that country's workbook. And at a later time, to uncheck the box and have the information dissappear from the country's workbook.

Please find the attached picture as an example of what I am thinking. Thank you in advance to anyone with advice! It is very much appreciated.


Excel Forum Picture 1.PNG