Importing Sheet

[kirkm]

What's the best way to move a whole sheet from one .xls to another?

Can you click and drag ? Or use code ?

The move, insert, copy options seen to be only within the same .xls

Thanks - Kirk

 

[Office_Novice]

The code found here works well for me.

http://www.rondebruin.nl/copy7.htm

 

[FSt1]

hi
manually, coping the sheet then pasting it into a new book works good.
with code...
Sub addmore()
ActiveSheet.UsedRange.Copy
'Cells.Copy' or copy the whole sheet
Workbooks.Add
'Worksheets.Add'or to a new sheet in the same book
Range("A1").PasteSpecial xlPasteAll
msgbox "Done"
End sub
which is best? both work....how often do you do this or need to do this?

Regards
FSt1

 

[kirkm]

Many thanks for the help, guys. I did have difficulty with both
suggestions though.... then I figured out how the in-built
Move/Copy dialog worked.

Instead of 'Move Selected sheet" (which you don't do)
it should say 'Move Active sheet' then the Before Sheet list
and the To Book dropdown all starts to make sense.

Cheers - Kirk