I've been trying to make this work, but just can't get it. An alternative which would suffice is to find the last cell with a specific format, which in my case would be a date (Mar-22).
I am needing to write a macro which finds the most recent month and copy and paste said month into the next column to the right. For some reason these summary formulas (YTD, rolling average, etc.) are getting in the way of things. They are listed to the right after a blank column and Excel keeps recognizing them as the most recent month then inserting a column to the right of them.
The rectangle in the red is where I would like the Macro to take the most recent month (Mar-22) and copy paste for use in the next month. Please advise.
Thank you!
I am needing to write a macro which finds the most recent month and copy and paste said month into the next column to the right. For some reason these summary formulas (YTD, rolling average, etc.) are getting in the way of things. They are listed to the right after a blank column and Excel keeps recognizing them as the most recent month then inserting a column to the right of them.
The rectangle in the red is where I would like the Macro to take the most recent month (Mar-22) and copy paste for use in the next month. Please advise.
Thank you!