Hierarchy in excel
 

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 location
structure

In product Structure all locations are clustered together

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

Prod Structure


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

In Location structure all prods are clustered together


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

Awaiting u r reply


--
jamshaggy
------------------------------------------------------------------------
jamshaggy's Profile: http://www.excelforum.com/member.php...o&userid=36664
View this thread: http://www.excelforum.com/showthread...hreadid=564115

Hierarchy in excel
 

hmm i dont get it, try explain better


"jamshaggy" skrev:


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 location
structure

In product Structure all locations are clustered together

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

Prod Structure


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

In Location structure all prods are clustered together


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

Awaiting u r reply


--
jamshaggy
------------------------------------------------------------------------
jamshaggy's Profile: http://www.excelforum.com/member.php...o&userid=36664
View this thread: http://www.excelforum.com/showthread...hreadid=564115

Hierarchy in excel
 

Exactly, so I. Try to describe precisely what data do you have and what do
you want to get.
Mario

U¿ytkownik "excelent" napisa³ w
wiadomo¶ci ...
hmm i dont get it, try explain better


"jamshaggy" skrev:


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 location
structure

In product Structure all locations are clustered together

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

Prod Structure


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

In Location structure all prods are clustered together


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

Awaiting u r reply


--
jamshaggy
------------------------------------------------------------------------
jamshaggy's Profile:
http://www.excelforum.com/member.php...o&userid=36664
View this thread:
http://www.excelforum.com/showthread...hreadid=564115