Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy-Paste Alternative Needed...
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
expert help needed for better alternative to slow workbook | Excel Worksheet Functions | |||
ALTERNATIVE TO SUMPRODUCT NEEDED | Excel Worksheet Functions | |||
Copy and Paste help needed - tia! | Excel Worksheet Functions | |||
How to select data series to format? (alternative needed) | Charts and Charting in Excel | |||
Vlookup Alternative Needed | Excel Discussion (Misc queries) |