Vba for sort data then total

Hello

We need a vba solution for my problem.. which is that .. we have a large data more then 49000 roads.. which is unsorted data..
We want this data to sort then totling also with following condition

Sort Data
First sort Assembly (COLUM C) then sort Nature of Works (COLUMN J)
then sort District (COLUMN B)

after sorting se need also TOTALING with first Nature of Works (COLUMN J) then Assembly (COLUM C) and then District (COLUMN B)

we have 3 type nature of work (PATCH, RENEWAL & SR),, in a assembly possible all type nature of work,, may be 1 type work may bhi 2 type work...
In a district possible many Assembly.. with different name.. (maximum 10) we want Assembly Total and in Last we want District Total..

We can sort this with Sort option in excel but.. we dont know how to 3 type total done automatically in excel .. so we need to vba solution..
my sample data is also attach with output what we want

Thanks in adavance..

Santosh

hello jeff .. thank for ur respoce.. and advice.. actualy ur current provided code only sort.. not totaling.. as per my need...

well i m not knowing much more about pivot table option ...so we need vba...

we are enclosing my new file hope this will b open..

Thanks for ur reply..

Santosh

Hi Jeff.. well don't know why my sample file not open ur end..
any way thanks for valuable suggestion.. we are trying to find some vba code with this forum or googling..

hope any other expert will look this matter..

thanks again jeff..
we add rep..

Hi ck sir ur provided code working as per my need.. only 2 thing more 1 formating issue and 2nd Serial Number issue..
hope this will also solve in this vba..

Thanks for ur valuabel code..

hi ck sir and jef sir with both off contribute we got solution
thank