Hierarchy in excel

  • Thread starter Thread starter jamshaggy
  • Start date Start date
J

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
 
Back
Top