View Single Post
  #1  
Old October 8th, 2009, 03:04 PM posted to microsoft.public.excel.misc
Currently Challenged ...
external usenet poster
 
Posts: 1
Default Microsoft Excel 2007 - VBA To Sort Table And Copy To Another Sheet

I have a table in Microsoft Excel 2007 (TableT - Range A130 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.