Hello,

I got a list of items in P10:P20.

I want to be able to doubleclick a cell in P10:P20 and its contents should be copied and pasted
in cell G9.

The next time I double click on a cell in P10:P20 I want it to skip to the next empty cell in the G column.

I found a couple of different soloutions but none that skips to the next empty row.

Can anyone help me get started?

Thanks in advance!