| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel 2007 - VBA To Sort Table And Copy To Another Sheet
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort Rows Pivot Table-Excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table sort -Excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table Data Column Sort Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 can not filter / sort in sheet with 657,000 rows | Excel Discussion (Misc queries) | |||
| is teher any way to copy excel sheet on microsoft word....... | Excel Discussion (Misc queries) | |||
Threaded Mode
