Thread: Creating Multiple Worksheet Sets Containing Linked Cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Stephane Quenson Stephane Quenson is offline
external usenet poster
  
Posts: 53
Default Creating Multiple Worksheet Sets Containing Linked Cells
After you have done the copy of the two sheets, select WS-B(2), select all
cells (grey spot at the intersection of rows and columns), then perform a
search and replace (Ctrl-H) with search parameter (without quotes) "WS-A!"
and replace parameter (without quotes) "WS-A(2)!". Make sure, by clicking on
the Option button, that you have Within "Sheet" and Look in 'Formula"
displayed.
Reply With QuoteReply With Quote