Cecil, thank you for the macro. I will try it out.

In case an error has been made and someone has put the names of two
mayors for the same municipality and year, is there a way to add
something to the macro so that it flags this. Maybe, it could add
additional lines for the country and put at the country and year
intersections all the names found. It would be good also if the names
of the mayors were turned red when there is more than one for a country
and year.

It would be really good if this could be put in the macro also. Once
again, thank you.

Michel

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!