Need Filter Help

[ssvm]

I filtered for some records and would like to make a new spreadsheet of just those filtered records. Any direction on how to do this? Thanks in 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)

"ssvm" <ssvm.20g3ja_1135261200.8364@excelforum-nospam.com> wrote in message
news:ssvm.20g3ja_1135261200.8364@excelforum-nospam.com...
>
> I filtered for some records and would like to make a new spreadsheet of
> just those filtered records. Any direction on how to do this? Thanks in
> advance!
>
>
> --
> ssvm
> ------------------------------------------------------------------------
> ssvm's Profile:
http://www.excelforum.com/member.php...o&userid=29848
> View this thread: http://www.excelforum.com/showthread...hreadid=495501
>

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

ssvm wrote:
>
> I filtered for some records and would like to make a new spreadsheet of
> just those filtered records. Any direction on how to do this? Thanks in
> advance!
>
> --
> ssvm
> ------------------------------------------------------------------------
> ssvm's Profile: http://www.excelforum.com/member.php...o&userid=29848
> View this thread: http://www.excelforum.com/showthread...hreadid=495501

--

Dave Peterson