Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Cell From Subtotal Line To Detail Line
Exported data to excel is in subtotal form by customer number (ARAF09).
I need to copy the customer number to the detail rows just below the subtotal. The number of detail rows varies with each customer. Some have 1 line of detail and some have 10, 8, etc. . The customer number is in column B and I want to copy the data to Column C, a few rows down. Is this possible with a formula or function. Thanks in advance. The orverall goal is to be able to sort the detail data by customer number. Perhaps another method is better? Customer: ARAF09 ABC FLOORS INC Terms: Net 30 Days 6/29/2009 484756 Copy Here 4642.75 8/24/2009 494581 859.50 10/15/2009 503963 2267.37 10/26/2009 505528 146.95 10/28/2009 505847 599.20 -- Tickfarmer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
ON SUBTOTAL LINE CARRY FORWARD DENOMINATOR FROM PREVIOUS LINE | Excel Worksheet Functions | |||
how to copy a whole line according to one cell in the line to a di | Excel Worksheet Functions | |||
average Line created in an existing line graph- based on one cell | Charts and Charting in Excel | |||
How do you add a blank line automatically after the Subtotal line | Excel Worksheet Functions |