Hello tester, glad to hear from you, and no that's not awesome, it's just a userform.
One of the quirks with this thing that I never addressed is that it doesn't really behave 'til the second set of data is entered. I will fix that and get rid of that type mismatch. In the mean time just put in some phoney data on the first line for date, befores and bbls.
You say you cleared out the data so you could start with new data.... you do realize only the stuff on the entered data side is all that should be deleted, right? All those cells on the right hand side under calculated items are filled with formulas that will leave the cells blank if they need to be blank. Don't touch or delete anything there.
The show the Entry form request....
Alt + F8 will bring up the macros that you can run. Select the Show Tank Site Form then select the options button and you can assign it anything you want. I tend to use CTRL + m , apparently that is an unused combination in Excel and won't screw anything else up.
Number of rows of data it can store..... lets see, Excel 2010 has 1,048,576 rows. At entries of 1 row per day that's good for just under 2900 years.... is that what you call unlimited?
Seriously though, you shouldn't, and won't, need to copy-paste anything. Actually you shouldn't be pasting anything now, at worst you should only be grabbing the drag handle of a cell with a formula and dragging down. I only dragged the formulas down about 50 lines so I'd have some space to play with.
I know there is something about formatting as a table and Excel will automatically copy formulas down to a new row if it needs to, but I've never used that so will look into it.
Anyway you play with this thing, let me know of any thing else that needs tuned up and I'll get back to ya.
NoS