Delete rows from current month

[vicvallejo10]

Hi there,
I have a file with historic data which is weekly updated with a Month to date raw data can anybody help me to delete rows only from the current month? Date is on column B

And on column AC I have a =MONTH(B3) formula.

 

[vcoolio]

Hello Victoria,

If you mean just dates for the current month of May, mixed in with dates from other months, then this may help:-

Sub Test()

Application.ScreenUpdating = False

        With Sheet1.Range("B2", Sheet1.Range("B" & Sheet1.Rows.Count).End(xlUp))
                .AutoFilter 1, 7, 11
                .Offset(1).EntireRow.Delete
                .AutoFilter
        End With

Application.ScreenUpdating = True

End Sub

The code needs to be placed in a standard module and assigned to a button.

I've used Sheet1 (the sheet code) not the sheet name in the above code. You may need to change this to suit.

The code won't require the help of the =MONTH formula.

I hope that this helps.

Cheerio,
vcoolio.

 

[vicvallejo10]

Hi vcoolio, thank you for taking the time to help me I really appreciate it.

Yes from the current month, I think it is not working, an error appeared.

I changed Sheet1 to DGMPStoreScore tab and assigned it to Delete prior button but it was not sucessfull. Any other ideas?

 

[vcoolio]

Hello Victoria,

This is totally different from your opening post.

Are you deleting rows of data from the Dashboard sheet or the DGMP Store Score sheet? If it is the DGMP Store Score sheet, is it set out as per the image in your opening post?

Cheerio,
vcoolio.