You can probably use one of these macros and modify it to then copy only a
specific number:

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

--
Regards,
Tom Ogilvy

"Byron" wrote in message
...
I have a list of 20 or so part numbers, each with 20 or 30 of each part
number. I want to display only a specific number of each of those part
number on a new worksheet.

for instance, I have 20 of one part number, but only want to move the four
(or some other number as defined by an external list) to a new worksheet.
Then I want to look at the next part number, which might have 30 pieces,
but
I only want to move 6 (again, as defined on this external list).

Any creative ideas?