Filter the Excel based on yesterday date

[vamshikrishna]

Hello Team

I have some data in excel and wanted to filter the data based on yesterday date, i want it to happen by writing macro, can you help me

 

[vletm]

vamshikrishna
eg A-column has dates.
You could continue from this ...

Sub Filter_Yesterday()
    With ActiveSheet
        .Range("A:B").AutoFilter
        .Range("A:B").AutoFilter Field:=1, Criteria1:=xlFilterYesterday, Operator:=xlFilterDynamic
    End With
End Sub

 

[vamshikrishna]

Hi

thank for the post, my requirement is like below
i have the data in excel like 9/10/2018, 9/11/2018, 9/13/2018
considering today is 9/14/2018, i want to filter the date of 9/13/2018

 

[vamshikrishna]

vamshikrishna
eg A-column has dates.
You could continue from this ...

Sub Filter_Yesterday()
    With ActiveSheet
        .Range("A:B").AutoFilter
        .Range("A:B").AutoFilter Field:=1, Criteria1:=xlFilterYesterday, Operator:=xlFilterDynamic
    End With
End Sub

Hi

thank for the post, my requirement is like below
i have the data in excel like 9/10/2018, 9/11/2018, 9/13/2018
considering today is 9/14/2018, i want to filter the date of 9/13/2018

 

[vletm]

vamshikrishna
... hmm? org was wanted to filter the data based on yesterday date
Isn't today ... current day and yesterday ... one day before today?
Now, You would like to name 'today' to any day and filter 'one day before Your named day' ... or how?
> You should upload a sample file
which would also show
how You would give 'Your today'?

 

[vamshikrishna]

vamshikrishna
... hmm? org was wanted to filter the data based on yesterday date
Isn't today ... current day and yesterday ... one day before today?
Now, You would like to name 'today' to any day and filter 'one day before Your named day' ... or how?
> You should upload a sample file
which would also show
how You would give 'Your today'?

Hi
U can see the attached file i want to filter yesterday date

 

[vletm]

vamshikrishna
As answered in #2 Reply.
..
Now, Your A-column has date & time ... no matter!
It works as You asked ... i want to filter yesterday date
Press the button

 

[vamshikrishna]

Thankyou it really worked, got the Idea, implemented, thank