Can you copy all of the ranges to one worksheet? Then you could just
use Advanced Filter to get a list of unique values.

http://www.contextures.com/xladvfilter01.html#FilterUR



HTH,
JP

On Apr 4, 6:48*pm, Appalachia
wrote:
In Excel 2007 -
I have two Spread Sheets.
Both have a column with 'City' names.
How can I get a resultant list of unique 'Cities' in a new sheet listed
alphabeticaly?

e.g.

Sheet 1 * * * * * Sheet 2 * * * *Sheet 3
A1 * * * * * * * * *A1 * * * * * * * *A1
New York * * * *Rome * * * * * London
New York * * * *Paris * * * * * *Madrid
London * * * * * Madrid * * * * *New York
Rome * * * * * * New York * * *Paris
* * * * * * * * * * * * * * * * * * * * *Rome

Thanks
--
Confusion will be my epitaph...