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=564114