Hi Guys,
I need macro which will be filtering the data for last month and deleting the others, for example: when I do report in December I need only data for November, I do report in January I need only data for December etc. I actually found only below code but it shows data for December, not for November like I want. Hope you will be able to adapt it for my requirements. Moreover, I attached a file. Thanks for advance.
[VBA]Sub filtering()
Dim startDate As Date
'startdate as long for excel
Dim lstartDate As Long
'get start date, day = always 1
startDate = DateSerial(Year(Now), Month(Now - 1), 1)
lstartDate = startDate
'filter everything before current month
'you see this month + future
ActiveSheet.Range("C1").AutoFilter Field:=3, Criteria1:=">=" & lstartDate
End Sub
[/VBA]