I don't you want to "sort".
You want to "filter".
Record a macro whilst doing the filtering for "X" or "Y" and doing the
copy and paste
Gord Dibben MS Excel MVP
On Thu, 8 Oct 2009 07:04:03 -0700, Currently Challenged ... <Currently
Challenged ....DeleteThis@discussions.microsoft.com> wrote:
>I have a table in Microsoft Excel 2007 (TableT - Range A1:D30 on Sheet1 ...
>A1 to D1 are the Table Headers) that contains various information on Sheet1.
>I would like to Sort TableT where all rows containing an "X" in column A
>are shown. Then copy those rows and paste them on Sheet2 from A1:A30. Then I
>want to sort TableT where all rows with a "Y" in column A are shown. Then
>copy those rows and paste them on Sheet2 A30:A60. Is there VBA that I can use
>to automate this? Thanks for your help.