Hi JKR

I update the macro on my site to avoid problems with the extension.
http://www.rondebruin.nl/copy5.htm#workbook

Sometimes you must help Excel to think <g



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Found it in my mail box (many mails to answer there)

Will look at it today or tomorrow


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JKR" wrote in message ...
Hi Ron,

I had sent you an e-mail 10-25 with an attached Excel file that you could
look at. Please let me know if you have received and if you have had a
chance to look at it.

Thanks!

Jackie

"Ron de Bruin" wrote:

Strange, send me the workbook private so I can test it for you

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JKR" wrote in message ...
Ron,

Thanks again for your help. The function produced 65 files. All of the
files seem just fine, except that some of the files do not have an XLS
extension (about 24 files). I cannot figure out why. Can you point me in
the right direction to have all of the files created have the XLS extension
or what to look for?

"Ron de Bruin" wrote:

Hi JKR

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JKR" wrote in message ...
I have a worksheet with multiple columns. After the data has been sorted
(say descending by column L - lets say column L is the customer name). Is
there a macro that can be run that would automatically save a sheet named for
each unique occurrence in customer and have just the rows for that customer,
saving as many sheets as there are unique customer names?

Thanks in advance for any help that you may be able to offer.