Re: $$Excel-Macros$$ is it possible to reduce this sorting code

2015-07-09 Thread ashish koul
Sub MULTI_LEVEL_SORT() '1ST level SORT ON NAME COL A '2ND level SORT ON START DATE COL B '3RD levle SORT ON END DATE COL C Sheets("Sample").Range("a1:d" & Sheets("Sample").Range("a1").End(xlDown).Row).Sort _ key1:=Sheets("Sample").Range("A:A"), order1:=xlAscending, _ key2:=Sheets("Sample").Range("B

$$Excel-Macros$$ is it possible to reduce this sorting code

2015-07-09 Thread Rohit Jadhav
Hi I want to sort a range say a1 to j15 containing various details of one's mutual fund portfolio like company name, fund name, fund type, no of units held, NAV , dividend received etc. I have created sorting code from excel but is it possible to reduce this code. I am using a separate function