Thread: Copy Filter Results only
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Copy Filter Results only
Autofilter results?

My Excel 2003 you just select the rows you see and copy/paste.

If you can't do that for dome reason, F5SpecialVisible cells onlyok.

Copy/paste.


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 16:31:19 -0800, Maureno
wrote:

How do I set the filter so that I can copy only the filter results vs. the
filter results & the underlying data that was hidden.

Reply With QuoteReply With Quote