View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
TomPl TomPl is offline
external usenet poster
 
Posts: 342
Default change links to a different source in the same workbook

Use the search and replace proceedure to search for sheet B and replace with
sheet A.

Tom

"LA Horowitz" wrote:

I have links in sheet C that link to sheet B but now I need them to link to
sheet A instead. Is there an easy way to change all the references in sheet
C? or do I have to manually change them? I found help on changing the
source workbook but I can't find anything about changing links to different
worksheets in the same workbook. Thank you.
--
LA Horowitz