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.
>
> >
>
--
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
