how to merge sheet between files

H

han

hello all!
I wonder how do this function in my program: copy a file's first sheet
into another excel file. Currently i am doing copy-and-paste but i wonder if
there is a better way?
thanks!
 
D

dvt

han said:
hello all!
I wonder how do this function in my program: copy a file's first
sheet into another excel file. Currently i am doing copy-and-paste
but i wonder if there is a better way?
thanks!
Click to expand...

Right click on the sheet tab of the sheet that you wish to move. Select
Move or Copy. Select the destination book and location. Don't forget to
check the Create a Copy box.

Dave
dvt at psu dot edu
 
Top