How copy several sheets from one Excel file to another excel file?

[Ai_Jun_Zhang]

Hi!

I would like to copy several sheets from one Excel file to another excel file. Is there any easy way to do that instead of copying one at a time. Is it also possible the sheet name is automatically copied?

Please advise,

Aijun.

[Gord Dibben]

Select first sheet then hold CRTL key while selecting other sheets one at a
time or hold SHIFT key and select last sheet.

With the sheets now grouped, right-click on sheet tab and "Move or Copy"

Click "create a copy" and "to book". Select "new book" if you don't already
have one open.

Click on OK and the selected sheets, including names, are copied to new book.


Gord Dibben Excel MVP

On Thu, 21 Jul 2005 17:51:43 -0500, Ai_Jun_Zhang
<Ai_Jun_Zhang.1sjl6c_1121987114.7472@excelforum-nospam.com> wrote:

>
>Hi!
>
>I would like to copy several sheets from one Excel file to another
>excel file. Is there any easy way to do that instead of copying one at
>a time. Is it also possible the sheet name is automatically copied?
>
>Please advise,
>
>Aijun.

[aaron.kempf@gmail.com]

hey keep your DATA in a DATABASE and report on it from 100 different
places

copying your data around is a waste of time

[Ai_Jun_Zhang]

Thanks, Gord,

I follow your steps and it works. Thank you very much for your help.

Aijun.

Select first sheet then hold CRTL key while selecting other sheets one at a
time or hold SHIFT key and select last sheet.

With the sheets now grouped, right-click on sheet tab and "Move or Copy"

Click "create a copy" and "to book". Select "new book" if you don't already
have one open.

Click on OK and the selected sheets, including names, are copied to new book.


Gord Dibben Excel MVP

On Thu, 21 Jul 2005 17:51:43 -0500, Ai_Jun_Zhang
<Ai_Jun_Zhang.1sjl6c_1121987114.7472@excelforum-nospam.com> wrote:

>
>Hi!
>
>I would like to copy several sheets from one Excel file to another
>excel file. Is there any easy way to do that instead of copying one at
>a time. Is it also possible the sheet name is automatically copied?
>
>Please advise,
>
>Aijun.