Champ
You're not getting any responses to your post because what you wrote
doesn't make any sense. You say that you want to list EACH part number on a
separate sheet and that you have 60,000 part numbers. That will produce
some 60,000 SHEETS. I don't think that's what you want.
Please post back and describe what you have. Not what you want. Just what
you have.
If you have some part numbers repeated and this fact is significant to your
query, then so state.
Then describe what you want to do. Go through, in words, what you want to
do with the first part number. Be complete from step 1 to the last step.
Remember that no one in this newsgroup has any idea of what you have, what
you want, your business, etc. HTH Otto

"Champ" wrote in message
...
Looking up the same part numbers from multiple pages and listing each one
of
them on a separate sheet, in a row, no matter how many part numbers are
returned, then carry on or two of the neighboring cells information with
it.
For instance: (I have 60,000 parts to look up and carry to another sheet
times 18 sheets)
p/n used for: tsi:
123 bmw 3:00:02
456 saab 6:00:03

Any help is much appreciated,
Thanks,
Champ