copy linked worksheet

P

PJaglom

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!
 
M

Marcelo

hi, PJaglom,

try to use find and replace to change A to A2

hth
regards from Brazil
Marcelo

"PJaglom" escreveu:
 
S

SimonCC

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
 
P

PJaglom

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.
 
Top