macro needed for sorting txt in a ceratian manner
Hi,
I have records of customers with names and address info as below in an excel
sheet on column A:A:
=================
Name of Customer A
Adres of customerA
Name of Customer B
Adres of customerB
.....
....
...
Name of Customer XY
Adress of customer XY
=========================
The number of lines used for the address info may vary from one customer to
another. But there is at least one "empty" line between each customer. I
also don't know the exact number of customers...It's a long list.
I need to sort this list onto another sheet in the workbook, so that the
names will reside under column A and corresponding address info's on column
B.
|