Help required: Automatically completing a list

  • Thread starter Thread starter Vinnie
  • Start date Start date
V

Vinnie

I have a lengthy list (app. 8500 rows) in the following format:

Customer1 OrderNum1 Line1 Value
Line2 Value
OrderNum2 Line1 Value
Customer2 OrderNum1 Line1 Value
Line2 Value
Line3 Value

Is there a formula / macro which would, for the empty cells only, copy
the value of the cell above ? Basically I need the list to look like:

Customer1 OrderNum1 Line1 Value
Customer1 OrderNum1 Line2 Value
Customer1 OrderNum2 Line1 Value
Customer2 OrderNum1 Line1 Value
Customer2 OrderNum1 Line2 Value
Customer2 OrderNum1 Line3 Value
 
Hi

Select the column / range of Customers. Then Edit / Go to / Special /
Blanks. This will
select all of the blank cells in the range. Type = and hit the up arrow and
then type Ctrl Enter. To fix these values use Copy then Paste Special /
Values.
 
Back
Top