Copy-Paste Alternative Needed...

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.
 
F

Fred Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top