Need Filter Help

S

ssvm

I filtered for some records and would like to make a new spreadsheet o
just those filtered records. Any direction on how to do this? Thanks i
advance
 
B

Bob Phillips

Data>Filter>Advanced Filter

You need to create a criteria range, but it allows you to filter to a new
location.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
P

Pete_UK

Insert a new worksheet if you don't have any spare. Highlight the
records after filtering, click <copy>, click the tab for your other
(new) worksheet and position cursor where you want the records to
start, then press <enter>

Pete
 
Top