Find empty cells, fill with text from cell above

[Marketer]

I have a spreadsheet where not every row is filled in first column. for
example, column 1 is customer name, column 2 is sales category, column 3 is
the customer sales for that category. A customer that purchased in 3
categories, only has the company name on the first record. So, the records
with no company name...are actually records for the same company above it.

I'm trying to figure out a way to search all cells in column 1, and if the
cell is empty, populate it with the text from the cell above it.

 

[Ron de Bruin]

Hi Marketer

See
http://www.contextures.com/xlDataEntry02.html