View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ted[_6_] Ted[_6_] is offline
external usenet poster
 
Posts: 12
Default Automatic Sorting?

I have a worksheet.

Row 1 contains column headers
Row 2 is blank
Rows 3 through row 548 contain data in columns A through W

First sort condition: Column F, smallest to largest
Second sort condition: Column B, smallest to largest
Third sort condition: Column A, smallest to largest
The number of data rows changes constantly - can range from 300 to 600 (or
more) rows.

How can I sort the data automatically?

Thank you,