Copy multiple sheets to new workbook

Is there an easy way to copy four or five sheets in one book to a new workbook?



Thank you for any help.


Josh

Select the first sheet to copy. If all the sheets are together, hold shift while selectiing the last sheet to copy. If they are spread out, hold control while selecting each sheet to copy. With the desired sheets selected, Edit->Move or Copy Sheet...->work through dialog->OK and the selected sheets will copy. If that's not easy enough, you can modify Ron de Bruin's VBA code to do what you want.