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?


--
LAF
------------------------------------------------------------------------
LAF's Profile: http://www.excelforum.com/member.php...fo&userid=9656
View this thread: http://www.excelforum.com/showthread...hreadid=346017

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 EditMove 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 |:)

"LAF" wrote:


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?


--
LAF
------------------------------------------------------------------------
LAF's Profile: http://www.excelforum.com/member.php...fo&userid=9656
View this thread: http://www.excelforum.com/showthread...hreadid=346017