Hierarchy in excel

[jamshaggy]

Hello Friends

I am new member here ... right now i am struck with one prob in excel
We have 2 structures 1 st product structure & another is locatio
structure

In product Structure all locations are clustered together

eg Prods are : A, B C. & locations are 1,2,3 etc

Prod Structure Location structwould be


Total Total
A 1
2 B
3 2
B A
1 B
2
3 3
C A
3 B
C

Is there any way in excel where excel would look at prod structure the
location structure would generate with the help of macros ????

Awaiting u r repl

 

[via135]

hi!

pl specify
In location Structure all product are clustered together

-via135