I have two worksheets in a workbook. I'll call them A and B. Sheet B has
references (links) to sheet A. I would like to be able to copy these sheets
so that the new sheet B2 has the same links to the new sheet A2, but no
matter how I do it, my new sheet (B2) always links back to the original sheet
A.

Does any one know of a quick way to do this?

Thanks!

hi, PJaglom,

try to use find and replace to change A to A2

hth
regards from Brazil
Marcelo

"PJaglom" escreveu:

I have two worksheets in a workbook. I'll call them A and B. Sheet B has
references (links) to sheet A. I would like to be able to copy these sheets
so that the new sheet B2 has the same links to the new sheet A2, but no
matter how I do it, my new sheet (B2) always links back to the original sheet
A.

Does any one know of a quick way to do this?

Thanks!

You can save your workbook to a new workbook. Changes the sheet names to A2
and B2. Copy the two sheets from new workbook to original workbook. Discard
the new workbook afterwards.

-Simon


"PJaglom" wrote:

I have two worksheets in a workbook. I'll call them A and B. Sheet B has
references (links) to sheet A. I would like to be able to copy these sheets
so that the new sheet B2 has the same links to the new sheet A2, but no
matter how I do it, my new sheet (B2) always links back to the original sheet
A.

Does any one know of a quick way to do this?

Thanks!

I tried that already. When I copied the sheets to the old workbook from the
new one, it changed the links to still link to the new workbook. In other
words, the references became external references to the worksheets in the
new, temporary workbook. There's gotta be an easy way to do this.

"SimonCC" wrote:

You can save your workbook to a new workbook. Changes the sheet names to A2
and B2. Copy the two sheets from new workbook to original workbook. Discard
the new workbook afterwards.

-Simon


"PJaglom" wrote:

I have two worksheets in a workbook. I'll call them A and B. Sheet B has
references (links) to sheet A. I would like to be able to copy these sheets
so that the new sheet B2 has the same links to the new sheet A2, but no
matter how I do it, my new sheet (B2) always links back to the original sheet
A.

Does any one know of a quick way to do this?

Thanks!

Have you tried to copy the info but only Paste Special and values only?

--
Saruman
---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------

"PJaglom" wrote in message
...
I tried that already. When I copied the sheets to the old workbook from
the
new one, it changed the links to still link to the new workbook. In other
words, the references became external references to the worksheets in the
new, temporary workbook. There's gotta be an easy way to do this.

"SimonCC" wrote:

You can save your workbook to a new workbook. Changes the sheet names
to A2
and B2. Copy the two sheets from new workbook to original workbook.
Discard
the new workbook afterwards.

-Simon


"PJaglom" wrote:

I have two worksheets in a workbook. I'll call them A and B. Sheet B
has
references (links) to sheet A. I would like to be able to copy these
sheets
so that the new sheet B2 has the same links to the new sheet A2, but
no
matter how I do it, my new sheet (B2) always links back to the
original sheet
A.

Does any one know of a quick way to do this?

Thanks!