Hello,
Recently I posted about creating a spreadsheet to manage a glass hire service I run. I have managed to help create a spreadsheet that almost works perfectly and allows me to place new orders, and track old orders. It even returns an error message if you try to book more stock out than is available on the day.

However, I am looking to add the function to alter the total inventory stock on hand - so that when new glasses are purcahsed or glasses are broken we can input the new total and the computer will look at all current booked orders and let us know if these are going to be affected.

I think I'm looking to program a macro that will use the lookup function? But I'm not sure if this is the right thing to do, or if someone else could suggest an easier way of accomplishing my goal.

Thanks