how to merge sheet between files

  • Thread starter Thread starter han
  • Start date Start date
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!
 
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
 
Back
Top