Use VBA to copy and name a work sheet

[fgruhlke]

I have a report sheet that can be updated by the user by selecting the name of an employee in a drop down.

I would like to build macro to create a copy of that work sheet, and name the new work sheet with the name of selected employee. The newly created copy would retain all the formatting but none of the formulas of the original sheet.


I can get it to make a copy but it retains all of the formulas of the original with Obvious problems!

Any ideas to get me started?

Thanks guys...

[patel45]

Please Login or Register  to view this content.

[fgruhlke]

This will work! Thanks!!