How to copy several worksheets

[hunycombs]

How do I copy several worksheets at one time... I am currently right clicking copying and I need to have 30 plus of the same worksheet... IS THERE AN EASIER WAY !!!! thanks

 

[prabby25101981]

If the worksheets are in one workbook, you can press CTRL, and click all worksheets that you want to copy. This will select them all. Now, you can copy them all at once...

 

[hunycombs]

YEA IT WORKED !!!!!!! thanks