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