Hi all,

Query I would like to build:

I have a list of names in column A.

I have a second list of names in column B.

If a cell in column A is empty, replace that cell with the value from column B (right next to it).

example:

John Bob
Jill Jackie
Mary Matt
(emptycell) Jason
Bill Frank

After macro:
John Bob
Jill Jackie
Mary Matt
Jason Jason
Bill Frank

Please help.
Thank you!