How can i mass copy a sheet?

[tripflex]

I have 100 sheets that are all identical. They are numbered 1-50. I now am in need of 100 sheets instead of just 50. Is there some quick way to mass copy the sheet? What about the naming of it? Do i have to do then all one by one or is there some tool i can't find that will copy the sheet and change the name to like 51 then 52 then 53, etc etc...

Thanks a ton guys, you've helped me out more than you know!

[shg]

Try this

Please Login or Register  to view this content.

It will double the number of worksheets each time it's executed.