Transposing Rows/Columns with Calculations

Maybe :

Please Login or Register  to view this content.

This works perfectly. Thanks a million A couple of quick questions on the code:

1. I've placed ActiveWorkbook.Worksheets.Add after the loop to add the results in a new tab. Where do I set the starting row for the new tab?
2. I've tried moving the Quantity column by increasing the number of materials in the column. Your code works perfectly. So do you look for the last column and take the quantity from there?

Thanks again. Really appreciate this.

You are welcome, thank for the rep. points.

Please Login or Register  to view this content.

- Where do I set the starting row for the new tab?
I set the TargetCell by adding the green lines

- So do you look for the last column and take the quantity from there?
Yes

Excellent! Thanks again for all your help.

You are welcome, glad I can help.


Regards