Solved

Exel Filtering Records

Posted on 2013-12-24
2
229 Views
Last Modified: 2013-12-24
Say,

I am using the filter function in excel. Once i have filtered my selection, how can I copy only the filtered records into a new spreadsheet or alternatively remove all the records that were not filtered. In other words - i would like to end up with a new spreadsheet containing only with the filtered information that was filtered.

Any method pls....?

TX
0
Comment
Question by:shaunwingin
2 Comments
 
LVL 7

Expert Comment

by:Jeggburt
ID: 39737901
What version of Excel are you using?

Generally, when you filter (I'm assuming you used Autofilter), you should be able to select all the data by highlighting the filtered cells.

When that is completed, you should be able to copy the data, create a new workbook/worksheet and paste the filtered data without the other data from coming over.
0
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39737904
Hi

pls refer to
http://www.melanieestes.com/joomla/index.php/blog-articles/entry/excel-copy-and-paste-only-the-filtered-data

Select your range then Goto (Ctrl-G in my version) then Special then select Visible Cells only

Now you can copy your filtered data and paste it where you want

Regards
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question