I have just started up a home business and want to use excel to keep up with my inventory. I would like to use the spin button to increase and decrease the values for each individual item (by increments of 1). I have a column for "Items Ordered", and one for "Items On Hand" (and I also want to have a "Sold" column). The "Items Ordered" will be a simple spin button. In the "Items On Hand" column, I would like to have the spin button to increase with the top button. But on the bottom button, when it decreases the value of "Items On Hand," I want it to also increase the value in the "Sold" column.

Also, I have a lot of rows to do this with, is it possible to fix multiple cells at once or will I have to do each one?

Thanks,
Spreadsheet impaired (or Si for short)

P.S. this is my first post on Excel Help Forum.