stanleykobeblue
New Member
- Joined
- Jan 4, 2005
- Messages
- 25
I've created a template in a worksheet that has all but 4 cells protected. I need to make 50 copies of this worksheet in the same workbook so it can be individualized for 50 people. However, when I copy & paste the formatting does not carry over nor does the comments in the data entry cells. Using Move/Copy works but I don't want to do that 50 times. Is there a way to use Move/Copy and stipulate how many copies I need?