Copy text to cell, but if targeted cell is full, copy to next one

[Marpik]

Hello,
I would love for your edvice. I am making form in which I have List1 where I fill the values and if certain conditions are met I want to copy the value to List2, which is summary of the inserted values.
I know how to do the copy if conditions part, but I am stuck at this:
Let's say if targetted cell A1 is <0 I want the value not to replace A1 but to be copied to A2. If the A2 is occupied, move to A3, etc...
This way it should create continuous list of values.

Thank you very much for any helpful answer!!
Mark

[Eastw00d]

Hi, welcome to the forum,
just a wild solution, something like this?:

Please Login or Register  to view this content.

In plain English:
If A5 is occupied then check cell below that until the next cel is empty, then copy A1

Cheers
Erwin