Just forgot to mention that "Field 2" means Second column in which filter is applied....
On Fri, Jan 9, 2009 at 11:10 AM, Tariq Kamal <tariq.kamal....@gmail.com>wrote: > Hi Shay, > > The code for filtering is > > Sub filter1() > > Dim count As Integer > Dim i As Integer > count = "12" > For i = 1 To count > Selection.AutoFilter Field:=2, Criteria1:=Cells(i, 4) > Next i > End Sub > > What you need to do is write down the name of all the months in one column > say column D (that's why cells (i,4) ) starting from first row...This way it > will go to row 12 and hence the definition of i from 1 to count, where count > = 12 > > Hope this helps.. > > Regards > Tariq Kamal > http://www.gate2quality.com > http://www.rideahead.blogspot.com > > > On Fri, Jan 9, 2009 at 10:35 AM, shay shay <shahinarafi...@gmail.com>wrote: > >> Hi All, >> >> can any one help me with a filter macro which will filter the all >> the invoices based on monthly basis like jan , feb etc and I also want to >> cretae pivot as well as chart togethere and this pivot and chart shd update >> automatically. >> >> -- >> Shay >> >> A Thinker tends to use reason and logic >> >> A feeler tends to use values and subjective Judgement. >> >> Be a Thinker in Life. >> >> >> >> > > > -- > > -- http://www.gate2quality.com http://www.rideahead.blogspot.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
