Combining 2 Excel (xls) files

L

LAF

I have 2 xls workbooks with different sheet names and both with
different range names. I would like to combine them both into one
workbook so that I don't have to re-create all of the range names. Is
there a way to do that?
 
C

CyberTaz

Hi LAF-

Open both files (let's call them A & B, and assume A will be your "combined"
file).

Working in B, select the sheets to be copied,

Go to Edit>Move or Copy Sheet, select A from the list & pick where you want
the sheets copied to. ALSO-> Put a check in the box to Create a copy. Once
you've confirmed success you can always trash workbook B.

Hope this is useful |:>)
 
Top