Combining 2 Excel (xls) files

  • Thread starter Thread starter LAF
  • Start date Start date
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?
 
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 |:>)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problems getting this macro to work 23
Macro to automatically save document with cell reference as filena 1
Combine worksheets in multiple workbook in one workbook with a macro 2
Indirect and sumif functions with multiple workbooks 1
Dynamic named range reference from external workbook 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Multiple workbooks to one worksheet 3
vlookup using different workbooks 4

Back
Top