Take Qty. from column A insert that Qty of rows on a seperate sheet. Then take the product ID from Column B and insert it in every row inserted. How is this accomplished? Any help would be appreciated. It needs to be able to take this from a total of about 1000 rows and transfer to the other sheet. Not all rows will have a qty and will therefore hopefully be skipped.

HELP!

Eric