Auto fill type formula

Hi, im trying to find a formula for my business spreedsheet that would make it easier/faster to input values and cut down on mistakes.
Its a kind of auto fill formula i guess, ill try to explain what i need.

When a value is put into cell A1 it will automaticlly be placed into the next free space in the B column.
If Column B already has values in B1, B2, B3 then the next value placed in Cell A1 with this formula will transfer the value to B4.
Maybe add a type of update button so once all the information is filled out then the update button is pressed it will transfer the values to the required sheets/cells
Will this be doable?
Would this need some kind of macro setup?

Sorry if this doesnt explain what im after very well, i just dont know how to draw up an example in excel that would give a better idea

Thanks

That looks like something that would make it easier to input multiple values in the right places. Only problem is, i dont know anything about macro so im kind of stuck again on how to get this to work.
If someone could setup a basic version of this macro for me to look at and work with that would be good.

Something i would be looking at would be....
Sheet 1 with the macro with 2 options Date and Price (doesnt have to be these 2, just an example)
Sheet 2 Cell A1 will be the date column and B1 will be the Price column

With every update i input into the macro will place the values in the next row down on each A (date) or B (price) columns.

I will play around with it a bit too see if i can figure it out myself but if anyone can just draw up a basic one like i described above that would be very helpfull.

Thanks

Could anyone tell me if what im trying to do is possible?

Yeah thats bassiclly what im after, now i just need to find out how to change it to my needs, which i guess learning a bit on how to write/change the code and what it all means.

Starting work on it now, just going to draw up a simple one for now to see how it works. But first i need to read up on how to get macro into the sheet cause ive never worked with macros before.
Thanks for the help

Ok I think ive figured it out, but im getting some error '400' box popup when i click the submit and im not sure whats causing it.
I will post a copy of what ive done for anyone to check it out and tell me whats causing the error box to come up.

I have something else to ask about this now.
I've got products setup with units and price and i need to send each units value to one sheet and each price value to different sheet and at the same time i need the date to be used in both of the data sheets.
How can i incorporate this into the same submit button? Im still not too sure on whats what in the macro code.

Heres the workbook
http://coronac.zoomshare.com/files/Book1.xlsm

Thanks

I need to split the data to onto 2 different sheets because its 2 different things and if i had it all tranfered to 1 sheet then it would make the sheet much too long and difficult to find the product that im looking for if i need to reference back to it in the future.
Im sure i had the Option Explicit at the top