Copy filtered list in Excel

Asked By spicer 10 points N/A Posted on - 09/26/2011

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. 

• Status: Open
• Question Views: 1822
• Answer Count: 3
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by pankajvishwakarm

Go To Solution

Answered By roger9 0 points N/A #81361

Copy filtered list in Excel

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.

About roger9

Questions
0

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 09/26/2011
• Question Category: MS Excel

Best Answer

Best Answer

Answered By pankajvishwakarm 0 points N/A #81364

Copy filtered list in Excel

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

About pankajvishwakarm

Questions
0

Answers
26

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 01/17/2012
• Question Category: MS Excel

Answered By Irshad Ahmed Khan 0 points N/A #81365

Copy filtered list in Excel

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

About Irshad Ahmed Khan

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/09/2012
• Question Category: MS Excel