Input number which is then added to bottom of a column and cell is reset to blank

This may get you started. The input cell is A1, result cell is C1. The Column is B.

Please Login or Register  to view this content.

this looks like its maybe VBA?? I don't know how to use what you've given me.

what I had done was

=lookup(9.99+307,1/($a$1:$a$500<>""),$a$1:$a$500)

this gave me the last number I inputted, but I don't understand how to use what you've sent

I'm sorry I though you were looking for a VBA approach.

I am if someone will give me the basics of how to use it.

don't have a f11, using a surface pro

Can you attach the file or a sample? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

I have no idea what surface pro is either.

ok working on my desktop now. Opened Microsoft Visual Basic -Book 1 .

Nothing inside editor is open to paste into. tried looking for 'New' under file but not there either.

FYI Surface Pro is new desktop/laptop by Microsoft. Powerful like a desktop fully functional but portable.

If you are in the VBA Editor then over too the left hand side you will see the Workbook Name with some sheet names listed below. Select the sheet that you wish the code to operate on. There will be a dropdown now on the right side Choose Worksheet from the left and Change from the right. The code goes there. However, I think it will have to be modified. You have not specified the input, result and the Column. I only used a sample. I have to go offline now. If you don't get the solution you are after, I'll be glad to help you when I come back on.