Might be possible with VBA??
I have a workbook with 12 sheets for every Month. Sheet Names are January-2019 etc all the way to December-2019
In every sheet in cell R3 i have written 2019.
Is there a way to change 2019 to 2020 in cell R3 and the sheet name will change to January-2020??
Thanks in advance for your help
I have a workbook with 12 sheets for every Month. Sheet Names are January-2019 etc all the way to December-2019
In every sheet in cell R3 i have written 2019.
Is there a way to change 2019 to 2020 in cell R3 and the sheet name will change to January-2020??
Thanks in advance for your help
Last edited: