If there's always a blank line above the customer name, I would do it this
way:
A1: =b1
A2: =if(b1="",b2,if(b2="","",a1))
Copy down your 15,000 rows.

Regards,
Fred


"Turp" wrote in message
...
Here is my problem...

In cell B1 there is a customer name
In cell B2 there is a order number for that customer
In cell B3 there is a order number for that customer
In cell B4 there is a order number for that customer
In cell B5 there is a total for that customer
In cell B6 there is a blank line to seperate customers.
In cell B7 there is a different customer name
In cell B8 there is a order number for that customer
In cell B9 there is a order number for that customer
In cell B10 there is a order number for that customer
In cell B11 there is a total for that customer
In cell B12 there is a blank line to seperate customers.


Every new order number is on the a new line ( there can be 1 order or 50
orders depending on the customer.)

What I need to do is copy the customer name next to (column A) their
orders.
Is there a easier way to do this besides Copy - Paste... this takes
forever
since I have over 15,000 lines.