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 a

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.