[Solved] Copy data to an empty cell

[dwarfer1]

hi all
is there a way to copy data from one cell and paste it into the first empty cell in a different column.
eg. data i want to copy is in cell A1 and i want to copy cell A1 and paste it into 1st empty cell in column B.
can this be done by looking up the 1st empty cell in column B using a formula.
many thanks
shaun

[MrProgrammer]

data i want to copy is in cell A1 and i want to copy cell A1 and paste it into 1st empty cell in column B.

Find Last Empty Cell in a Row → "I want to copy the value of "A1" and paste it to the last blank/empty cell in column B. "

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[dwarfer1]

lets see if I can make this simpler.
lets say my data is in cell A1. what I want to do is create a macro so that when I press a button it copies cell a1 and pastes it in to b1. if I press the button again paste to b2 and if I press it again b3 etc. is this possible.
many thanks
shaun

[Zizi64]

lets say my data is in cell A1. what I want to do is create a macro so that when I press a button it copies cell a1 and pastes it in to b1. if I press the button again paste to b2 and if I press it again b3 etc. is this possible.

"Everything" is possible by macros. But you must WRITE it.


Do you want to fill the COLUMN "B" based on the values typed-in the cell "A1"?

[dwarfer1]

Yes Zizi but only when I press the button. and each time I press the button I want it to move down to the next cell in column b

[Zizi64]

When jou want to fill a column (or a cellrange) with some data, then you can use the "Data form" feature of the LibreOffice. Select a cellrange to fill, and then from the menu: Data - Data Form.

(It is not available for the AOO by default, but you can install it as an extension.
https://extensions.openoffice.org/en/project/dataform

The extension was written in Basic language. Maybe you can write some similar macro based on the code.)

[robleyd]

If Zizi64's suggestions don't meet your needs, perhaps you could explain what it is that you are actually trying to achieve that needs the process you are describing; there may be an alternative method of achieving your goal. See the XY Problem

[dwarfer1]

cannot download the extension. so here is what I am doing hope some one can help. I have created a darts scoreboard which works great. it works out your averages and lets you know what finish to go for. at the end of each game I want to keep a record of each players dart average. I could manually input this at the end of each game but thought it would be easier if I could just click a button and record this. hope this makes sense to you guys and I would appreciate any help.

many thanks
shaun

[dwarfer1]

Managed to solve this my self. If you select a cell that has data in it then hold down ctrl then press the down arrow it goes to the last cell in that column that contains data. if you then press the down arrow again it goes to the next cell wich is empty. I just recorded a macro doing this and assigned it to a button. alls well