*I was working on my data sheet and countered with one problem **I required filters in two row ranges on being specific I want first filter to be placed for data range from Row no. 1 to 200 and second one I want for Row no. 210 to 350.
So I try to do it with filter options that are available in Excel 2007 & Excel 2010 Beta but not getting it but whenever I put filter on second range first filter goes disappear so with the help of search on various options I got the answer for this problem. And it is here for help of our group members also this we can do without macros. First Go to Insert ribbon in MS Excel 2007 Click on Table "Create Table" Window will open * *Select the data range* *Mark My Table has headers option * *And repeat same function for another range you will get the desired results. * *Regards Hemant* -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
