I am trying to plan a production schedule using excel.
Products are scheduled based on the allergen content of the product.
Build up of allergens where possible e.g. 1st product may contain Gluten, the next product may contain Gluten and Milk.
Because the 2nd product contains Gluten which is contained in the 1st product, an allergen clean down is not required however if the 2nd product contained Egg and Milk a clean down would be required as we would be introducing a new allergen.
There may numerous combinations of allergens.
I am looking to use excel to create a production schedule based on the allergen content of products whilst minimising the number of clean downs required i.e. the most efficient.
I also need to consider if the products are vegetarian as these to need be run first.
Is it possible to use excel to create something like this?
Maybe using macros?
I want it to pull info by just entering the code of a product and pull info from another worksheet which contains the product details.
Note I have no experience with macros.

Thanks