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