Macro that will delete rows based on greater than current date

Closed
Report
Posts
4
Registration date
Monday May 2, 2016
Status
Member
Last seen
May 5, 2016
-
Posts
3569
Registration date
Friday February 6, 2015
Status
Moderator
Last seen
July 18, 2016
-
Hello,
I want a macro that will delete rows that are greater that the current date so if today is 2016-05-05 I want it delete all rows with something greater than that.
But let's say today is 2016-05-06
I want it to delete all rows that are greater than the current date

Column A Column B Columns C Column D
2016-05-05 Tst123
2016-05-04 Tst456
2016-05-08 Tst789
2016-05-10 Tst987
2016-05-07 Tst894
2016-05-06 Tst654
2016-05-05 Tst864
2016-05-05 Tst076

Column A Column B Columns C Column D
2016-05-05 Tst123
2016-05-04 Tst456
2016-05-06 Tst654
2016-05-05 Tst864
2016-05-05 Tst076

1 reply

Posts
3569
Registration date
Friday February 6, 2015
Status
Moderator
Last seen
July 18, 2016
878
Hello,

To provide help, regarding this formula's is not easy one, no body spent time and run the formula's on their own pc and provide help to others, but here in CCM there are some volunteers who provide help in taking time to workout with the formulas you asking for, by executing on their own pc.

Therefore during asking for help you should be polite and responsible of giving respect. Please add Hello (appreciate, grateful, etc.) in the Beginning of your query and ending it by Thank you. So that it is a big thing you did for whom you help.

Hope you understand.

Generally according to our Charter we can't answer the questions who didn't follow our politeness charter. Instead we close that topic.

Please, copy, modify and repost your message respecting the politeness charter.

For CCM politeness charter please read this article:


https://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others#politesse

Thanks.