So, you really need a database, not an excel spreadsheet! It will AUTO INCREMENT as you are asking. You can set it up to do your calculations for each BOX! If you don't know how to make a macro that will do this, you are on the same level of knowledge as with a DATABASE, and you get ALOT further using a solution that will SCALE! Have fun with that on an excel sheet!