View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Turp Turp is offline
external usenet poster
 
Posts: 1
Default Copy-Paste Alternative Needed...

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.