Filter & sort a list

  • Thread starter Thread starter Sudipta Sen
  • Start date Start date
S

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.
 
Hi,
highlight the whole range and sort it firs by amount due and as 2nd option
by company,
 
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
 
Back
Top