Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 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 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=564113 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hierarchy in excel
hi! pl specify In location Structure all product are clustered together -via135 jamshaggy Wrote: 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 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=564113 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |