I have used a filter in my VBA code to sort a date column Oldest to newest.
List of dates:
9/12/2018
9/15/2018
10/15/2018
11/26/2018
12/1/2018
12/30/2018
1/5/2019
1/30/2019
2/1/2019
3/1/2019
etc
I would like code to keep everything prior to current date in same grouping as current month then insert a blank row after the 12/30/18 another blank row after 1/30/2019 and another blank row after 2/1/2019.
I've been struggling. Started with If statements then thought I'd go to Select Case. I can't get it all to come together.
Thanks for the help.
Chad
List of dates:
9/12/2018
9/15/2018
10/15/2018
11/26/2018
12/1/2018
12/30/2018
1/5/2019
1/30/2019
2/1/2019
3/1/2019
etc
I would like code to keep everything prior to current date in same grouping as current month then insert a blank row after the 12/30/18 another blank row after 1/30/2019 and another blank row after 2/1/2019.
I've been struggling. Started with If statements then thought I'd go to Select Case. I can't get it all to come together.
Thanks for the help.
Chad