Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating hierarchy in excel | Excel Discussion (Misc queries) | |||
How do I set up hierarchy in Excel? | Excel Discussion (Misc queries) | |||
Hierarchy in excel | Excel Discussion (Misc queries) | |||
Hierarchy in excel | New Users to Excel | |||
Is Relational Hierarchy Possible with Excel | Excel Programming |