Sorting on column a,b,c,& subtotal on 2 criteria on multiple columns

[chirag050675]

Dear Sir,

SUBJECT:- REQUIRE VBA MACRO FOR SORTING-& THEN SUBTOTAL - “A” COLUMN WISE , THEN BY “B” COLUMNS WISE WITH GRAND TOTAL -ALSO EXPAND & COLLEPS BUTTON ON LEFT OF SHEET

I have a an excel sheet with data

BASIC SINARIO OFANY WORKSHEET WHEN READY TO PROCESS

1. A1 to end of “A” -Dynamic (A1 have heading, not fix where is the end of data on “A”-depend on situation)
2. Columns A to right side –Dynamic (not fix how many columns on right side from columns A-but this is sure that each columns have heading)
3. First requirement is Sorting-on A, Ascending order, then by Columns B (Ascending ) & then BY column C (Ascending)
4. After short require Subtotal on “A” wise on any 4^th or 5^{th nd} columns of right side of A (flexible on situation)
5. Without replace on A ,Then by subtotal Columns B wise on 4^th & 5^th column.
6. Can successfully working Expand-collapse buttons on left side (like excel provide us after subtotal)
7. First row should be stay there even scrolling down (freeze panes)

if you can help me..for VBA , I will be thankful

Regards,
Chirag.

 

[chirag050675]

Dear all
I think last cell reset is necessary before each process of subtoal may be range
Change on each subtotal process due to sobtotal display line ladded after each
& it is necessary to select whole range for next lavel subtotal
What your suggestion??

 

[chirag050675]

Dear All,

can anyone help me in this very small process???


politely waiting ...
Regards,

Chirag

 

[chirag050675]

I am in search for Excel macro
for above requirement.<o></o>

Data Position

(1) Total database just spread in in columns A to F
(2) Columns A's Data's End not fix (Dynamic) <o></o>
(3) first-require macro for whole data Sort onA then Sort on B
(4) Requirement Subtotal should be in Columns D,E,F
(5) first of Each changes in Columns A-->> Subtotal columns D,E,F then by
(6) Each changes in Columns B-->> Subtotal columns D,E,F

that's it...Very simple & basic situation ...Require VBA Macro for above .
I also attached link of my Excel file contain sheet1 row data + in sheet 2 require resul

https://drive.google.com/open?id=0B78Gzwyf_-eUOU9MMVpwaDVULXc

can anyone help me??<o></o>
Regards,
Chirag


<o> </o>

 

[chirag050675]

I AM VERY SADLY DECLARE THAT THIS IS CROSSPOSTED QUESTION--Sorting on column a,b,c,& subtotal on 2 criteria on multiple columns

Dear All helpful people from this and another forum..
after realize about cross posting's effect....
I am in very sadly feeling (sorry to all) & declare that I CrossPosted this question on
http://www.ozgrid.com/forum/showthread.php?t=201190

so .."before waste your valuable little time" toanswer this question...request to just click
& bird viewing on above link... (that already closed) also forcheck that "any one answered this question???"& I am also ready to suffering for long time waiting..to get answerthis question......<o></o>
because 1 more rule hurt me that...same question can't repeat in any forum so now I am in trapped condition....I can notask this question again in any forum ..though its closed... <o></o>

but I promise.....if anyone can help either that forum or this forum....
...I just put that link on both forums... <o></o>
I don't want that my little simple question leads to toput frustrations any one...<o></o>
I just don't want that my little question's answerwritten in fearful & depressed condition....<o></o>
i don’t want to start “Cross Posting War” due to i believe<o></o>
<o> </o>
“Jealous is most powerfulterminator of knowledge... it destroy everything” & also it cant do help toothers.... <o></o>
"Knowledge must not become huge wait onmind"...& There are 1 more rule on this mortal planet..<o></o>
"any one can't go from this planet with Full ofknowledge & things with him" <o></o>
this earth's property..& mortal things &knowledge must put on this earth before die...<o></o>
that is one & only rule in world Iappreciate....

so there are one situation. If somebody deeply know that rule can even help meother wise i pass this situation on god...

<o></o>
regards,
Chirag

 

[chirag050675]

Re: I AM VERY SADLY DECLARE THAT THIS IS CROSSPOSTED QUESTION--Sorting on column a,b,c,& subtotal on 2 criteria on multiple columns

Dear All,

if any body from both forum can't answer my question.in within your decided time,
then I request to both forum to close this thread..

Regards
Chirag