recipe formulation 2.0.xlsmThanks, I will make sure to mark it as solved as soon as I figure out how to get it to work in my exact excel spreadsheet. I hate to make people do my work and I want to learn, that is why I just used a example sheet. I'm currently trying to get it to work in my sheet. Once I get it to work I will mark this as solved. Until then you both have been very helpful and I would like to keep it open for a little while I get this worked out. Cheers

I'm going to post my exact sheet and maybe if you guys find time can take a look at it and it might speed up my questions in the future as I'm trying to add my own sheets to the code you both have wrote.

In my sheet. Recipes that is what I was using in my example sheet 1. I need column A to move to Either Grain2, Hop2 or Other2. I'm using the list used on the sheet called Inputs for my list.