View Single Post
  #1   Report Post  
Excel_Challenged
 
Posts: n/a
Default What formula will sort data in a separate worksheet%3f

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.