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