couple problems. I know it's somewhere in my spreadsheet
My spreadsheet is a basic inventory sheet. It starts with an amount and you can subtract amounts and it gives you the remaining amount. It also copies changes onto a second worksheet. Anyway, my issue ( not a big issue but nontheless), is that when you enter an amount under "used footage" and hit enter, it does not go down to the next row in the column automatically. Also, ( not a big issue) is that I have intentional blank cells in column "TYPE" that can be manually entered with text. If I leave those cells blank it kind of screws up my inventory worksheet ( "CopperHistory"). Is there a way to enter a formula so that the blank cells in column A ( TYPE) fill in with some text automatically? It can be any text as long as anytime there is a blank cell in column A it fills it in with something. attached spreadsheet to understand what I'm saying because I'm an idiot.