Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

Can you copy a list created by filter?

Posted by Kat on December 19, 2000 9:48 AM

Hi,
I am trying to copy a list created by a filter. How can I do that?
Thanks
Kat

Re: Can you copy a list created by filter?

Posted by SJC on December 20, 2000 10:28 AM

Highlight the list. Then click Edit, Go to, Special, Visible Cells Only. And then Copy.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.