When u select the filtered data press (alt+;) and then copy it..
On Thu, Feb 19, 2009 at 11:46 AM, Lavprasad Kori <lavprasa...@gmail.com>wrote: > > Hi Ajay, > > This is Lavprasad. The horizontal filter is very good. But I want to know > that when I copy the data filtered data then hidden data is also coppied. > For that what we have to do. > > Regards, > > Lavprasad > > > On 2/18/09, Ajay Varshney <ajayvarshney21...@gmail.com> wrote: >> >> The attached file can give you an idea to solve your problem. >> >> >> >> >> On Mon, Feb 16, 2009 at 4:49 PM, ram bhagath <rb.worldw...@gmail.com>wrote: >> >>> Hello Group members, >>> >>> If I have a data in a row wise, will use auto filter option. But If I >>> have data in coloum wise if I need to filter (horizental), how do this. >>> suppose if have column no. 1,2,3......100, if I want to see only 2,4,8 >>> like this.. If I go on hiding the col. ll tak more time. Is there any way to >>> do this..?? >>> >>> Please help me. Can we do this without VBA. >>> >>> >>> >>> Thanks >>> Ram. >>> >>> >> >> >> >> > > > -- > Thanks & Regards, > > Lavprasad Kori > MIS Executive - Water > Tel. 022 - 39833428 > > > -- Thanks & Regards, Harmeet Singh --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
