View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default edit formulas on a worksheet simultaneously?

Edit|Replace

Worksheet 2

Replace with
Worksheet 3

Mike

"ewb" wrote:

Excell question:
I have hundreds of formula links on one worksheet linking to a second
worksheet. Every cell formula starts with 'worksheet 2' and then the cell
reference. Is it possible to change, simultaneously, all these formulas to
on the first worksheet to 'worksheet 3'...and leaving the cell references the
same??
ewb