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.

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" <(E-Mail Removed)> wrote in message
news:4AAA1384-BE9E-4151-9AF2-(E-Mail Removed)...
> 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.
>
>
>