I am designing a workbook that will be used as a sign off sheet for employees. Every week I will be adding a new sheet with a formula which automatically calculates next week's date based upon the week before. Is there a macro or function that I can create that will allow one click to both create a copy of the previous sheet and automatically insert the date calculation formula into the copy of the sheet? Any suggestions on this would be greatly appreciated. Thank you in advance!
Not especially difficult, but if you want to use a macro to do this, then would it work to have the macro determine next week's date and insert it, rather than inserting a formula to calculate it? I assume that once a sheet is created and set up for next week's date, it will always have the same date.
The macro would look something like this:
This code creates a sheet called Template (change as necessary) to be the last sheet in the workbook, then inserts a date one week from today in cell A1 of the new sheet.
Please Login or Register to view this content.
no macro
sheet name is a number
Thank you very much! How would I change the macro to name the sheet based upon the date rather than a static name?Originally Posted by 6StringJazzer
Not especially difficult, but if you want to use a macro to do this, then would it work to have the macro determine next week's date and insert it, rather than inserting a formula to calculate it? I assume that once a sheet is created and set up for next week's date, it will always have the same date.
The macro would look something like this:
This code creates a sheet called Template (change as necessary) to be the last sheet in the workbook, then inserts a date one week from today in cell A1 of the new sheet.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks