Question: Merging two columns; only overwriting blank cells

[Kimb]

Hi, I was search online and found old thread Merging two columns; only overwriting blank cells with the solution below which works great but only if I type in the =K7 formula in each cell. I will have 1000's of blank cell after I do a Xlookup. Is there anyway to get the formula to auto fill all the blank spots? I know there are Macro out there and honestly I don't use marco's much because I normal deal with over a 100 columns and 1000's or rows and I have not learned enough about Marco's to be rewriting them daily to fix each new situation. Thank you for any advance you can offer. Kim

Select the whole range of column C.
Press control+G (goto)
Press alt+S (special)
Press k (blanks)
Press enter (ok)
Press the equals sign
Press the left arrow on the keyboard
Press control+enter

The effect is that all cells in column C that are blank, are filled with the value in column B... After, you will have formulas in there so you may want to copy and paste values on column C.

 

[JGordon11]

That procedure works for me. Make sure you pressing ctrl-Enter (not just enter) as the last step