Need Filter Help

[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

 

[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)

 

[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

 

[Dave Peterson]

filter your data
copy the visible rows and paste to the new sheet.