Maybe this one ?

http://www.rondebruin.nl/copy5.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Audio_freak" wrote in message . 2.2...


Thanks, great tool to find history. I traced a little further in
history, but didn't find it. I must have read the page while reading
other messages.

Thanks again.

P










Gord Dibben <gorddibbATshawDOTca wrote in
:

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