Hi Noorin i cant share the workbook its higly confidential anyway just
a code help or link is enough for me.
is this below code is right let me know
Selection.AutoFilter Field:=16, Criteria1:=ctr1
Selection.AutoFilter Field:=27, Criteria1:=ctr2
Selection.AutoFilter Field:=15, Criteria1:=ctr3
On Oct 19, 4:52 pm, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote:
> Dear ICWAI,
>
> Can you share Worksheet with group.
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>
>
> On Wed, Oct 19, 2011 at 5:11 PM, ICWAI Help <icwai.answ...@gmail.com> wrote:
> > Hello everyone could anyone please let meknow the code for Excel auto
> > filter using criteria from Combobox items
> > i have 5 to 6 criteria from a combobox in form and i need to extract
> > the data from excelsheet
> > if any link that also apprciated.
>
> > --
>
> > ----------------------------------------------------------------------------------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel- Hide quoted text -
>
> - Show quoted text -
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
