Hi Steve,

I'm not sure exactly what you have in cells A1, A2 and A3 in your example

Do you want the present inventory in A1, then enter a value in A2 representing how many you're removing or adding to the inventory and then you want A1 to update? That would require VBA but is possible. Or do you want something more complex?

ChemistB