Getting the whole recipe

Hello Guys,

I am facing a query for some time, I need your assistance in sorting this out.

I maintain recipe given by kitchen dept in order for cost control.

Pls see the attached file for the way i maintain the recipe info.

Now this recipe are presented in terms on item name and ingredients mentioned as the usage pattern.

However they are represented by an unique item code on the left side


It is very difficult to sort recipe based on the their unique item code.

Some time there is a requirement of only 50 recipes, it means the complete recipe, with all ingredients, not one ingredient of the recipes.

Thus it becomes very difficult to go in the complete file and remove each items, esp when there are more than 1000 recipes like this.

So, we need to remove all the recipe one by one. it almost take a day to compile a report

However, I have a method that I can collect the code of all these items, as they are all unique.(highlighted in color)

Is there some formula or macros, possible where i can just type in the item codes and all the recipe will appear in the output sheet.


Kindly assist.

Best Regards
AT