Macro to Delete Values that are the same and ref is similar based in dates

I have References in Col D , Dates in Col E and values in Col G


Where the Value in Col G in the prior Month is the same as the value in Col F relating to the last month and year in Col E eg June 2023 and ref in Col D is the same then delete these rows. Also if Diff in the values is within a tolerance of 050, then delete these rows


I have highlighted the items to be deleted based on my specifications above

try

Please Login or Register  to view this content.

Thanks for the help Jindon. Your code works 100%

Thanks for the reply bebo021999

If this scenario appears which is usually an adjusting entry, then all three rows can be deleted

Hi Jindon

Kindly amend code

Where Col I contains text like "Correcting" In Col I in the same row for the match items then these row must not be deleted

I have highlighted the items in Yellow that must NOT be deleted

Have you tried the code I last posted(#6)?

Hi Jindon


I tried post # 6. The items in blue to be deleted. The items in Yellow to remain intact is Col I contains "Correcting"

Is this what you mean?

Please Login or Register  to view this content.

Hi Jindon

This is exactly what I need-Many thanks indeed

One thing I care is that when the multiple similar rows appear and if only one of them has "correcting" in col.I.

The current code deletes only the row(s) without "correcting" in col.I, even other row has it.
If you don't want to delete any row if one of the similar row has "correcting" somewhere then change to

Please Login or Register  to view this content.

Thanks for your valuable input and amended code