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

"Sudipta Sen" wrote:

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.