$$Excel-Macros$$ Re: 2 FILTER IN SINGLE SHEET

2009-09-29 Thread Sandeep
Hi, I wanna tell you that fillter work in nested (One inside another) manner. Means after you apply one filter on a data the remaining data is according to you filter criteria. After this if you apply another filter ( Without removing the first one) then the filter is according to your first

$$Excel-Macros$$ Re: 2 FILTER IN SINGLE SHEET

2009-09-28 Thread Abhishek Jain
What I understand is that you want multiple filters on single worksheet...say, one from row 1 to 16 and other from row 17 to 30 and so onif i got your query right i am afraid it is not possible (as far as i know). Let's see if any of the geniuses of the can tell a work around. Rgrds On Sat,

$$Excel-Macros$$ Re: 2 FILTER IN SINGLE SHEET

2009-09-28 Thread Shelly Mehta
Dear Friends... I am novice in excel but I think the list function can help us out. It can be used in the following manner : 1. DATA - LIST - CREATE LIST Define range and tick on - My list as headers than u can use filters on both the data attaching for your reference

$$Excel-Macros$$ Re: 2 FILTER IN SINGLE SHEET

2009-09-27 Thread big smile
Respected members of group, I want the 2 filter option in Raws not in Columns. Is it possible. Thanks On Thu, Sep 24, 2009 at 10:21 AM, big smile bigsmile...@gmail.com wrote: Hellow group members, Have a nice time with excel master. I have query that can it possible to

$$Excel-Macros$$ Re: 2 FILTER IN SINGLE SHEET

2009-09-24 Thread Dilip Pandey
Dear Shah, You can assign autofilters in two data range within a worksheet, attached example has the solution for it. Though it is a tricky way, but yes it can be used to some extent. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com