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