Googling on your name, I found this thread about making new workbooks from
sheets.

May be the one you are referring to, although I don't see any URL to a website
other than Ron de Bruin's.

http://snipurl.com/6bgg

Gord Dibben Excel MVP

On 11 May 2004 20:53:51 GMT, "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.

I'd be very happy finding that again, now that I need it...

Thanks!

Peter