Hi all,
Is there any way of creating a macro that will create new worksheet inside of workbook with weeks numbering?
I have worksheet named WEEK-21, and want to have a macro that when used (I will assign macro button) will create a new worksheet with name WEEK-22 and so on. So after pressing assigned button I want to be able to create new worksheets with weeks numbering following the name of the first workbook, so WEEK-22, WEEK-23, WEEK-24 etc etc.
Any help will be greatly appreciated.
Is there any way of creating a macro that will create new worksheet inside of workbook with weeks numbering?
I have worksheet named WEEK-21, and want to have a macro that when used (I will assign macro button) will create a new worksheet with name WEEK-22 and so on. So after pressing assigned button I want to be able to create new worksheets with weeks numbering following the name of the first workbook, so WEEK-22, WEEK-23, WEEK-24 etc etc.
Any help will be greatly appreciated.