Hi,
I was wondering if anyone could help me as i'm a bit stuck on the following task. I need to automate the roll-forward of an excel spreadsheet where the year which is being increased by 1 is within text.
ABC2019ABCDEFG will need to be roll-forwarded to ABC2020ABCDEFG.
The issues I'm...