Update Previous month date using VBA

Hello,

I'm using below code - where it filters previous month, copies the previous months data at end of the row. Than the newly copied (previous month date) is updated to current month.

Please Login or Register  to view this content.

In column E i.e. Date 1 Column - I'd 10 records of Jun 2023. After running the code. June 2023 data is copied and updated as Jul 2023 (from row 36 in attached)

Now I have a requirement - once we have the current month updated in Date 1 column, in Date 2 column we should get the next month i.e. Aug 2023.

Highlighted in yellow in attached.

Hi Marc,

Thank you! This did the trick.

Really appreciate your support.