How to copy/autofill to last item if below cell is blank

You do not need a code for this task. Go special formula could do it.

Maybe:

Please Login or Register  to view this content.

@AB33: it's perfect.
@John: all value in Column A = "=A2" that's not what I want. I want blank cell = value of upper cell value.

Thank you very much for your time and help.
Regards,
tt3

Did you try it?

Hi John,
Yes I did try and it's not even working if cell A2 is blank. Maybe my question is not clear so you may take a look at sample in attached for more clear.

Regards,
tt3

Hello tt3,

use below code for given task:

Please Login or Register  to view this content.

Regards,
BS

Hi BS,
Thank you very much.

Regards,
tt3