Copy Value of another Cell if Blank

[Andrew.Trevayne]

Hi all,
Can you help me with a Macro again please?
What I wanted to do is to check for blanks in Column B, if its blank, it should copy the value shown in Column A.
In my attached example, cell B4 is blank, it should copy cell A4; cell B8 and B9 are blank, it should copy the values of A8 and A9.

Column A is always populated with value hence there is always something to copy.
Also, my rows can change from 10 to 500000.

Appreciate any help. I have attached my dummy spreadsheet.
Thanks in advance.

Regards,
Andrew

[bakerman2]

For starters.

Please Login or Register  to view this content.

[Alf]

As your number of rows may go up to 500000 perhaps autofilter is a faster option?

Please Login or Register  to view this content.

Alf

[Andrew.Trevayne]

Thank you both. Appreciate you taking time.
Cheers.

Andrew

[bakerman2]

Glad to help and thanks for rep+.

[Alf]

I second that

Alf