Hello,

I am utterly despaired, as I have to come up with a weird VBA code
although I have never used VBA before...

Here is the the thing:

I Have once Excel sheet (Sheet1.xls) containing two columns: Column A
contains the names of different persons, , & Column B the countries of
the respective persons in alphabetical order; e.g.

ColumnA ColumnB
Pablo Argentina
Estefan Argentina
Michael Austria
Stephanie Austria
Franz Austria
Jerome Belgium
Clara Belgium
Alvaro Chile
Mikele Chile
Emanuele Chile

However, the # of names per country, as well as the countries
themselves, vary from time to time, so the list is not constant!


I know have to export this list in a second worksheet (Sheet2.xls) such
that the countries are displayed as headers in ColumnA, and the
corresponding names are displayed below, whereby the alpabetical order
of the countries is kept and the countryname and the last preceeding
name of a person are separated by an empty row:

ColumnA (Sheet2.xls)
Argentina
Pablo
Estefan

Austria
Michael
Stephan
Franz

Belgium
Jerome
Clara

Chile
etc

The problem is that I have to come up with a Macro that recognises the
country name, displays it as a header, lists all the respectvie names
following this header, then recognises when a new country name comes
up, inserts an empty row, followed by the name of the new country and
the names of the people from this country...
As I said, so sometimes there may be just one name for a given country,
some times 5 names, and some times no names at all!

Any ideas??? Any help is mostly appreciated!
Many thanx!


--
burk
------------------------------------------------------------------------
burk's Profile: http://www.excelforum.com/member.php...o&userid=36955
View this thread: http://www.excelforum.com/showthread...hreadid=566702