[vadim0770]

Hi,

I have one worksheet with 3 colums and rows.
I need to create a new dinamic worksheet from the data on the 1st sheet.
Columns in the 1st sheet are:

Material Plant Quantity
------------------------------------------
AAA 1 100
AAA 2 50
AAA 3 20
BBB 1 30
BBB 3 10

I know descriptions for the Plants: 1 - "East", 2 - "West", 3 - "South".
I have to create macros or formulas to build a new worksheet from information on this one. It is basically take a Material group by, then Plant and sum of Quantity for that specific Material and specific Plant , and build a column for that specific Plant, with provided description. So if its Plant =1 , then column is "East", and so on.
So, essentially the new worksheet shooud look like this.
Quantity for Materials based on Plant.

Material East West South
-----------------------------------------------------------
AAA 100 50 20
BBB 30
BBB 10

Can someone give me tips on how to build that new worksheet and how should i build macro?

Thank you,
Vadim.