Importing an old workbook into a new workbook

J

Jean Larson

Hi,

I think my Excel Workbook may be corrupted and I was wondering how we
can copy, insert, or import an entire workbook that contains at least a
dozen work sheets in the original file.

Do I have to copy and paste each worksheet one at a time or can I just
import them all?

Jean
 
K

kkknie

Open both workbooks.
In the old one, right click a tab and select "Select All Sheets"
Right click a tab again and select "Move or Copy"
In the To book: drop down, select the new worksheet name.
Hit OK and they should all be moved. If you want to just copy them
check the create a copy button.
 
Top