Need help with existing macro to multiply results

Hello, I have an existing macro that will work to parse the data shown. This can be found here http://www.excelforum.com/excel-prog...-new-post.htmlI was wondering if it was possible to multiply the sku in worksheet 2 by the number that is above the SKU in worksheet one. This is the quantity the customer ordered. So for example below it shows product A as being purchased once and product B as being purchased twice. The quantity is in the cell right above the SKU. The result I want is below that~

Quantity Product Details Price
1 Product A
SKU: 7Z-36Q9-LK1P
ASIN: B009BTQ8S4
Listing ID: 0916M1DMLSL
Order-Item ID: 28255029918234
Condition: New $14.99 Subtotal:
Shipping: $3.66
________________________________________
Total: $18.65

2 Product B
SKU: QP-PQXS-3CA8
ASIN: B009FRAVUS
Listing ID: 0924M9480RX
Order-Item ID: 63126777937842
Condition: New $12.99 Subtotal:
Shipping: $6.34
________________________________________
Total: $32.32

ORDER TOTAL: $50.97

So worksheet 2 would look like this

7Z-36Q9-LK1P Product A
QP-PQXS-3CA8 Product B
QP-PQXS-3CA8 Product B

You can see since the item was purchased twice the SKU would show twice and give me a truer count. I would assume since the data is being multiplied by a set number given from within the data, it shouldn't be hard to integrate into the already great macro. I do appreciate everyone's help and look forward to hearing if its possible or not. Below is the macro code. Thanks again!

Please Login or Register  to view this content.

Try this amended code

Please Login or Register  to view this content.

My bad, try again

Please Login or Register  to view this content.