Attached an excel, user should be able to press a button and
1) new sheet is copied
2) Week number is added to cell F1(+1 from the copied cell). On the first sheet the weeknumber is inserted manually, but for the new sheets it could be automated.
3) new sheet is named "Week"+F1 value
End result: new sheet is copied, week number is updated, sheet is renamed.
The purpose of this excel is to use it as work allocation. Each week a new sheet is copied, where employees fill in their estimate of the coming weeks workload.
Having the week numbering coming automatically would be super, but since now I have not been able to figure out how to do it. Any help would be highly appreciated.
Bookmarks