Thanks Carim, the way I mention above works pretty good so I'm happy with that...thanks again.
Posts by cobber1418
-
-
Wow....a bit too complicated for me.....I need VBA.
Maybe I will filter for 'Unclassified'...copy and paste that to a new sheet, then return to my data and filter for 'Last' month and copy and paste that with the 'Unclassified' using VBA....I have done something similar before.
-
-
Yep....that change worked.....thanks heaps Carim.
-
Unfortunately it is getting 1/2/21...can I just change from :="<=" & prevDate to :="<" & prevDate.
-
Hi Carim, I need it to be dynamic ie whatever month I run it...it needs to get 'Last' month, cheers.
-
Do you mean like below......I tried and it only gets 1/1/21 instead of all Jan.
Code- Sub Olderthan2Months()
- Dim startDate As Long
- Dim prevDate As Long
- startDate = DateSerial(Year(Now), Month(Now),1) 'CHANGED THIS....ONLY GETS 1/1/21
- prevDate = Evaluate("=Edate(" & startDate & ",-2)")
- ' Adjust range to your specific situation '''''''''''''''''''''
- Range("A1:A15").AutoFilter Field:=1, Criteria1:="<=" & prevDate
- End Sub
-
Would it possible to remove the 'Day' part........I only need it to be month specific ie we are in March so I only need all Jan and previous, not a specific day in Jan.
Apart from that it work excellent....thanks heaps.
-
Please see sample attached
-
please see sample attached.
-
????? they are totally different questions
-
Being March now, I want to 'see' only Jan, Dec, Nov, Oct etc. I need it to be dynamic also, cheers.
-
Hi, I need to filter for 'Unclassified' and all last months dates in the same column. I tried the below code but it doesn't work, cheers. PS. this is completely different to my other post.....!
-
Hi Carim, thanks for your reply but it does exactly the same as my formula...Feb and previous months instead of Jan and previous months. More help would be much appreciated, cheers.
-
Hi, the below code filters last month and all months prior, but I would like to filter for two months prior ie in March I would like Jan and all months prior, cheers.
Display MoreCode- Private Sub Previous_Months()
- 'filter for previous months
- 'startdate as date
- 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)
- lstartDate = startDate
- 'filter FOR everything before current month
- 'you see PREVIOUS MONTHS
- Range("I6").AutoFilter Field:=8, Criteria1:="<=" & lstartDate
- End Sub
-
Thanks Jerry
-
royUK, it does work, I was only applying it to the first column in the rows. I applied it to the column headings and Items and it works great. Thanks again and sorry for the confusion, cheers.
-
-
They all get the data individually from a report. I'll keep checking your other suggestion, cheers.
-
Unfortunately a lot of people will be using it, so not an option, cheers.