Follow up question.

How do I move the formula to the right. (ie from Teq to Rum, Gin, Vodka ect.) In the actual sheet there are about 150 different liquors, so rewritting the formula for each column would be a bear, but if I paste the formula to a different column it changes the reference points.

Thank you,

Adam