I hoping someone can help, I have a template within the 2003 Excel Workbook, I need some help to duplicate the worksheet template based on the number of days working. I already have a cell calculation in (c2) to capture the results between the start date and end date. Also I would like the duplicated sheets to be renamed to match the dates selected.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copy Excel Template
- Thread starter wjmay1961
- Start date
-
- Tags
- excel 2003 template vba
Sergio, great work and I will be sure to share this coding with the other people on my team. I have one more question, If the contractor runs the procedure again, Is there a method for error handling letting the user know that a sheet already exist with same name?
Upvote
0
Excel Facts
Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
sergioMabres
Well-known Member
- Joined
- Feb 24, 2013
- Messages
- 946
when the first sheets gets renamed it will be an error and the macro will stop, an error handling routine could be added
Upvote
0
Similar threads
- Question
- Question
