Hi,

I'm looking to further sort a table that is already sorted. I need to do
this in a macro. I want only rows which say 'x' in column A and 'y' in column
B to be sorted by column C.

The table is already sorted so that items that have 'x' in column A and 'y'
in column B are at the top of the table (rows 1 through xxx)

Any advise?


--
H

For your already sorted worksheets,
All columns need descriptions on top row,
Select first for, then Data, Autofilter

More information on filtering at
http://www.datapigtechnologies.com/ExcelMain.htm
http://www.contextures.com/tiptech.html

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"hfazal" wrote in message ...
Hi,

I'm looking to further sort a table that is already sorted. I need to do
this in a macro. I want only rows which say 'x' in column A and 'y' in column
B to be sorted by column C.

The table is already sorted so that items that have 'x' in column A and 'y'
in column B are at the top of the table (rows 1 through xxx)

Any advise?


--
H