Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Saving a filter?
I am sorting a large spreadsheet. I have filtered down to my chosen rows, now
I want to save this as a separate sheet! |
#2
|
|||
|
|||
Press CTRL + A
Right-click Copy Click on a new sheet Right-click on A1 Paste -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "rik84" wrote in message ... I am sorting a large spreadsheet. I have filtered down to my chosen rows, now I want to save this as a separate sheet! |
#3
|
|||
|
|||
Or use (in a standard module) - **chg "Sheet2" name below, if necessary**:
Code By Tom Ogilvy (If I remember right) Sub CopyFilter() Dim rng As Range Dim rng2 As Range With ActiveSheet.AutoFilter.Range On Error Resume Next Set rng2 = .Offset(1, 0).Resize(.Rows.Count - 1, 1) _ .SpecialCells(xlCellTypeVisible) On Error GoTo 0 End With If rng2 Is Nothing Then MsgBox "No Data to copy" Else Worksheets("Sheet2").Cells.Clear Set rng = ActiveSheet.AutoFilter.Range rng.Copy Destination:=Worksheets("Sheet2").Range("A1") End If ActiveSheet.ShowAllData End Sub Hope this helps "Max" wrote in message ... Press CTRL + A Right-click Copy Click on a new sheet Right-click on A1 Paste -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "rik84" wrote in message ... I am sorting a large spreadsheet. I have filtered down to my chosen rows, now I want to save this as a separate sheet! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
Pivot table and filter | New Users to Excel | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions |