Excel 2007- Advance Filter

In all Office Version when we use Advance Filter copy to another Loaction, it
Gives me error , you can copy filter data in to active worksheet,so I need to
go to New worksheet and give the command.

So can't we have an icon in andvance filter to copy in an new workbook, or
new sheet.
--
Vipul C Dani
Assistant Training Manager
Prgati Software Pvt Ltd.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.office.misc

I don't understand what you are trying to do. Can you give a step by
step description of what you currently have to do and what you'd prefer
to be able to do?

Thanks,

Patrick Schmid
--------------
http://pschmid.net

"Vipul Dani" wrote in message
:

In all Office Version when we use Advance Filter copy to another Loaction, it
Gives me error , you can copy filter data in to active worksheet,so I need to
go to New worksheet and give the command.

So can't we have an icon in andvance filter to copy in an new workbook, or
new sheet.
--
Vipul C Dani
Assistant Training Manager
Prgati Software Pvt Ltd.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.office.misc

Vipul Dani wrote...
In all Office Version when we use Advance Filter copy to another Loaction, it
Gives me error , you can copy filter data in to active worksheet,so I need to
go to New worksheet and give the command.

So can't we have an icon in andvance filter to copy in an new workbook, or
new sheet.
....

It's a consequence of the perverse way Microsoft has implemented
Advanced Filters, specifically, due to this command creating the
worksheet-level name Extract. The braindead part is that it can only
create this Extract name in ActiveSheet, but it has no problem not
creating the worksheet-level name Criteria when the criteria range is
on another worksheet.

This is a very long-standing Excel annoyance that Microsoft may have
come to believe is a feature.

Finally, you'd be much better off asking Excel-specific questions in
Excel newsgroups.