T
Turp
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.
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.