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.
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 precedding name of a person are separated by an empty row:
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...
Any ideas??? Any help is mostly appreciated!