Hi Everyone,
Attached is a excel file test auto month.xlsx which I'm trying to set up a sheet that will populate the next 12 months based on the first column being the month we are up to. I've tried 2 separate methods however i'm encountering difficulties. I want it to be a formula based rather than VBA. Please see the 2 ways used in the sheet.
I would appreciate if someone can help me.
Thanks
Bookmarks