Experts, Pls find the attachment and find a solution, in that filter not working properly in the dates except 10/10/2010 & 11/10/2010, pls tell me the problem & help me to solve it. Regards Rajesh kainikkara
On 10/31/10, Rajesh K R <rajeshkainikk...@gmail.com> wrote:
> Experts,
> Pls find the attachment and find a solution, in that
> filter not working properly in the dates except 10/10/2010 &
> 11/10/2010, pls tell me the problem & help me to solve it.
> Regards
> Rajesh kainikkara
>
>
> On 10/30/10, ashish koul <koul.ash...@gmail.com> wrote:
>> Sub Macro1()
>> If ActiveSheet.AutoFilterMode = True Then
>> ActiveSheet.AutoFilterMode = False
>> End If
>>
>> ActiveSheet.Range("$A$1:$B$27").AutoFilter Field:=2, Criteria1:= _
>> ">=" & CDate(Range("g4").Value), Operator:=xlAnd, Criteria2:="<="
>> &
>> CDate(Range("g5").Value)
>> End Sub
>>
>>
>>
>>
>>
>>
>> On Sat, Oct 30, 2010 at 7:12 PM, Rajesh K R
>> <rajeshkainikk...@gmail.com>wrote:
>>
>>> Hi Experts
>>> thanks for ur promt reply.is it possible to give the from & to dates
>>> for filtering in specified cells and filter it by a macro eg:
>>>
>>> Sub applyfilter()
>>> > If ActiveSheet.AutoFilterMode = True Then
>>> > ActiveSheet.AutoFilterMode = False
>>> > End If
>>> > ActiveSheet.Range("$A$1:$B$27").AutoFilter Field:=2, Criteria1:= _
>>> > ">=$d$1", Operator:=xlAnd, Criteria2:="<=$e$1"
>>> > End Sub
>>>
>>> Regards
>>> Rajesh Kainikkara
>>>
>>> On 10/28/10, ashish koul <koul.ash...@gmail.com> wrote:
>>> > Sub applyfilter()
>>> > If ActiveSheet.AutoFilterMode = True Then
>>> > ActiveSheet.AutoFilterMode = False
>>> > End If
>>> > ActiveSheet.Range("$A$1:$B$27").AutoFilter Field:=2, Criteria1:= _
>>> > ">=10/31/2010", Operator:=xlAnd, Criteria2:="<=11/18/2010"
>>> > End Sub
>>> >
>>> > Sub RemoveFilter()
>>> >
>>> > If ActiveSheet.AutoFilterMode = True Then
>>> > ActiveSheet.AutoFilterMode = False
>>> > End If
>>> >
>>> > End Sub
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> > On Thu, Oct 28, 2010 at 4:44 PM, P.VIJAYKUMAR <vijay.4...@gmail.com>
>>> wrote:
>>> >
>>> >> Hi Rakesh,
>>> >>
>>> >>
>>> >> You can also change gridline colour or give colours to the cells in
>>> which
>>> >> you want to see your Cursor.To change thecoulour of gridline(if you
>>> >> are
>>> >> using excel 2007) Go to the Excel ribbon Button then go to the Excel
>>> >> option
>>> >> Button In that go to that advanced option. In that advanced option
>>> >> go
>>> to
>>> >> the Display options in that in the end you will have chage gridline
>>> >> Colour.you can select what ever coulour you want excep dark colours
>>> >> because
>>> >> dark clours Mix withthe cursor colour and you will get confused,
>>> >>
>>> >>
>>> >>
>>> >> Regards,
>>> >> VijayKumar
>>> >>
>>> >> On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R
>>> >> <rajeshkainikk...@gmail.com>wrote:
>>> >>
>>> >>> Hi experts
>>> >>>
>>> >>> Any one can help me to manage my problem to work in the lengthy
>>> database,
>>> >>> eg if selected a raw having a lot of field i am mistaken many times
>>> >>> to
>>> >>> identify the related name field. pls find the attachment regarding
>>> >>> the
>>> >>> problem & help me to find a solution.
>>> >>>
>>> >>> Expecting your valuable advise
>>> >>>
>>> >>> Regards
>>> >>>
>>> >>> Rajesh
>>> >>>
>>> >>> --
>>> >>>
>>> >>>
>>> ----------------------------------------------------------------------------------
>>> >>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>> >>>
>>> >>
>>> >>
>>> >>
>>> >> --
>>> >>
>>> >>
>>> >>
>>> >>
>>> >>
>>> >>
>>> >>
>>> >>
>>> >>
>>> >> P.VIJAY KUMAR
>>> >>
>>> >> --
>>> >>
>>> >>
>>> ----------------------------------------------------------------------------------
>>> >> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>> >>
>>> >
>>> >
>>> >
>>> > --
>>> > *Regards*
>>> > * *
>>> > *Ashish Koul*
>>> > *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
>>> > *akoul*.wordpress.com <http://akoul.wordpress.com/>
>>> > My Linkedin Profile
>>> > <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>>> >
>>> >
>>> > P Before printing, think about the environment.
>>> >
>>> > --
>>> >
>>> ----------------------------------------------------------------------------------
>>> > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>> >
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
>> *akoul*.wordpress.com <http://akoul.wordpress.com/>
>> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>>
>>
>> P Before printing, think about the environment.
>>
>> --
>> ----------------------------------------------------------------------------------
>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
--
----------------------------------------------------------------------------------
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
filtering.xls
Description: MS-Excel spreadsheet
