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 --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
