• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

Exel Filtering Records

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
shaunwingin
Asked:
shaunwingin
1 Solution
 
JeggburtCommented:
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
 
Rgonzo1971Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now