Calculations with multiple columns (Partnumbers in order and ammount)

[timo-osinga]

Hello, This is the current (example) situation. I need to calculate how much a partnumber is ordered and what is the total Qty of that part.

Date FA Task Barcode Jobcard Part Number Qty Part Description
24-01-2009 A06 T0003ABC book 123456 1 PAPER
24-01-2009 A06 T0003JKL seat 456789 2 ARMREST
25-01-2009 A05 T0003FJH seat 456789 30 ARMREST
25-01-2009 A05 T0003VBN plastic 321654 1 TRANSPARANT


Can u help with creating a macro for the following requirements (if possible)

I want the following columns:

1. Unique part numbers
2. Ammmount of ordered unique partnumbers
3. The Qty of each unique partnumber
4. The dates involved with each unique partnumber
4. The FA involved with each unique partnumber
5. the task barcode involved
6. Part description

so this need to be the result;

Part Number Ordered QTY Dates FA's Barcodes Part description
456789 2 32 24-01-2009, 25-01-2009 A05, A06 T0003JKL, T0003FJC ARMREST
123456 1 1 24-01-2009 A05 T0003ABC PAPER
321654 1 1 25-01-2009 A06 T0003VBN TRANSPARANT


Thanks a lot! if U have the time to help me. I am a beginner with macros and i have difficulties with creating this.

[nilem]

Hi Timo-osinga, try it (see attached file)

[timo-osinga]

Thank you very much nilem, it works and will save me lots of time!