That sounds like my "Update Sheets from Master' sample:

http://www.contextures.com/excelfiles.html

Under the heading 'Filters'

Audio_freak wrote:
A while ago I had a question, and was referred to a website where someone
had all kinds of excel documents with macro's in them, as examples.

Searching in the web just generates too much results, I can't find it
anymore.

Here's what I am looking for and once saw on that site:

A document with
- unsorted data in the first sheet, one column of which contains various
city names repeatedly coming back.
- a list of the city names in the second sheet
- a macro which creates separate sheets for each of the city names and puts
all the unsorted data into the relevant sheet.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html