Prev: Impact of Fees on Growth Rate
Next: Calculating Time Spans
From: jc on 23 Apr 2010 04:24
Hello
How can I export only the filtered values in one tab to a new tab?
From: ozgrid.com on 23 Apr 2010 04:33
Simply copy your visible range and paste. Else, use AdvancedFilter and
launch it while on your destination sheet.
http://www.ozgrid.com/Excel/advanced-filter.htm



--
Regards
Dave Hawley
www.ozgrid.com
"jc" <jc(a)discussions.microsoft.com> wrote in message
news:673DBFE8-3FF7-4B53-AB79-A38A7F871292(a)microsoft.com...
> Hello
> How can I export only the filtered values in one tab to a new tab?

From: Dave Peterson on 23 Apr 2010 07:54
Depending on the version of excel, the way you select the range to copy, you may
find that the hidden rows get pasted as well.

So make sure you select just the range you want to copy
Hit F5 (edit|Goto in xl2003 menus), Special|visible cells only
Go to the other worksheet
Select the cell to paste
Edit|Paste special|paste values



jc wrote:
>
> Hello
> How can I export only the filtered values in one tab to a new tab?

--

Dave Peterson
 | 
Pages: 1
Prev: Impact of Fees on Growth Rate
Next: Calculating Time Spans