Copy worksheets from file A to file B

I

ikkyu

Hi,

I would like to know how I can copy (not link) more than one worksheets from
file A.XLS to file B.XLS with everything (format, macros, etc)?


@+

Hepta

Time, is, the greatest thief
 
D

Dave Peterson

Open both workbooks.

Select the worksheets in A.xls that you want to copy (click on the first tab and
ctrl-click on subsequent).

then Edit|Move or Copy Sheet
Check the bottom "create a copy" checkbox.

And make the "to book:" B.xls

The macros behind the worksheet will go with the copy. The macros in General
modules (and other spots like ThisWorkbook) won't.)

But you could copy those general modules by dragging and dropping (and the
ThisWorkbook module by copy|pasting).
 
H

Hepta

Many thanks, Dave.

Dave Peterson said:
Open both workbooks.

Select the worksheets in A.xls that you want to copy (click on the first tab and
ctrl-click on subsequent).

then Edit|Move or Copy Sheet
Check the bottom "create a copy" checkbox.

And make the "to book:" B.xls

The macros behind the worksheet will go with the copy. The macros in General
modules (and other spots like ThisWorkbook) won't.)

But you could copy those general modules by dragging and dropping (and the
ThisWorkbook module by copy|pasting).
Click to expand...
 
Top