What formula will sort data in a separate worksheet%3f

[Excel_Challenged]

I have a worksheet that I'll call Wksht A. It contains data such as Bill
type, Bill Balance, Monthly Pymt and Interest Rate. I want to sort this
information by Interest Rate (highest to lowest) and then by Bill Balance
(lowest to highest). But I want the information to be sorted on another
worksheet - Wksht B.

What formulas will do this?

Thanks.

[Nick]

Pivot Tables are the best way to go for this.
Check out the help files in Excel.

Nick


"Excel_Challenged" <Excel_Challenged@discussions.microsoft.com> wrote in
message news:9CE636F7-3A47-4949-BB11-81C1AF37D01F@microsoft.com...
>I have a worksheet that I'll call Wksht A. It contains data such as Bill
> type, Bill Balance, Monthly Pymt and Interest Rate. I want to sort this
> information by Interest Rate (highest to lowest) and then by Bill Balance
> (lowest to highest). But I want the information to be sorted on another
> worksheet - Wksht B.
>
> What formulas will do this?
>
> Thanks.
>