View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default copy linked worksheet

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!