Copy filtered list in Excel

Asked By 10 points N/A Posted on -
qa-featured

I am using Microsoft Excel 2003. When I use auto filter option, it filters the data.

But when I try to copy that filtered data to another sheet it does not work.

The whole list is copied to another sheet. 

Microsoft Excel 2003-auto filter option-Excel list
SHARE
Best Answer by pankajvishwakarm
Answered By 0 points N/A #81361

Copy filtered list in Excel

qa-featured

Thanks for the question,

It's unfortunate that it's impossible to copy hidden rows of filtered data when copying filtered data to a new spreadsheet. However, it's possible to copy the visible filtered data and you need to follow just a few steps,

first, select the filtered data and press CTRL + C to copy the data.

2nd, select the spreadsheet where you going to paste the data.

3rd, Press CTRL + V to paste the data. Alternatively, select the data you want to copy, click on insert and select table, then you can transfer the data to another work sheet.

Excel-CTRL + C-select spreadsheet-CTRL+V
Best Answer
Best Answer
Answered By 0 points N/A #81364

Copy filtered list in Excel

qa-featured

Code:

Dim FilterCriteria
Dim CurrentsheetName As String
 
Add new sheet
CurrentsheetName = ActiveSheet.Name
Range("A1").Select
Selection.AutoFilter
Sheets.Add Type:="Worksheet"
With ActiveSheet
.Move after:=Worksheets(Worksheets.Count)
.Name = "Suspense"
End With
 
FilterCriteria = "blah blah"
Selection.AutoFilter field:=6, Criteria1:=FilterCriteria
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
Worksheets("Suspense").Activate
Range("A1").Select
Selection.PasteSpecial
Application.CutCopyMode = False
ActiveWindow.Zoom = 85
Cells.Select
Selection.Columns.AutoFit
Range("A1").Select
Worksheets(CurrentsheetName).Activate
Selection.AutoFilter field:=6
 
That's it.
 
Selection.AutoFilter
Answered By 0 points N/A #81365

Copy filtered list in Excel

qa-featured

Sometimes we face such a problem but don't worry dear friend follow the steps and get solution.

SOLUTION-1

Step-1:

Make a copy of that sheet which you want to filter.

Step-2:

Now, filter the copied sheet as you desire.

Step-3:

Select the filter data and cut it and past on another sheet.

SOLUTION-2

Step-1:

Make a copy of that sheet which you want to filter.

Step-2:

Now, filter UNWANTED data from the copied sheet.

Step-3:

Select the filter data, delete all rows and remove filter.

Conclusion

Solution-1 and Solution-2 are perfect solutions.

Hope it will solve your problem.

Thanks and regards.

IRSHAD AHMED KHAN

Login/Register to Answer

Related Questions