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

Try
http://www.rondebruin.nl/copy5.htm#all


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



"craig72" wrote in message
...

I have a list in a single worksheet that runs as follows:

Product no. Qty.
123 17
123 8
123 12
156 11
184 0
184 13

and so on.

I have used a function previously that allows a new worksheet to be
created within the workbook for each product no. Rather than cutting
and pasting each block of product numbers into its own worksheet, there
is a way to automatically create a new worksheet that, for example,
contains all the 123 product data in worksheet 1, all the 156 product
data in worksheet 2 etc.

Any ideas how to do it as I can't remember and can't find anything
related to it in the Excel help file?

Thanks in advance.


--
craig72
------------------------------------------------------------------------
craig72's Profile: http://www.excelforum.com/member.php...o&userid=35540
View this thread: http://www.excelforum.com/showthread...hreadid=553034