Filter & sort a list

[Sudipta Sen]

Created a list, where sl. no., Company name, Bill amt, Received Amt. & Due
Amt. columns are there.

Now Date wise bills details has been mainten by this list .

Now I want to get only the dues list to other sheet with sorted name of
compay. so I cd also get the subtotal of companywise and the grand total at
the end row.

How Can I do this.

 

[Eduardo]

Hi,
highlight the whole range and sort it firs by amount due and as 2nd option
by company,

 

[Sudipta Sen]

Thks for ur response.

But actually I want to get not only the sorted data, but also filter sorted
with their subtotal & grandtotal o sepearate sheet as report type. i.e

AA 15
AA 5
AA 10