View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shashi Bhosale Shashi Bhosale is offline
external usenet poster
 
Posts: 33
Default Changing a formula on the worksheet

I have a worksheet with hundreds of formula, each formula has a option to
check for a site.
ex:
=SUMPRODUCT((DataSite="ABC")*
(DataAcc=510115)*
(DataAcc<=510115)*
(DataAmount)
)

How do i change Site to 'XYZ' globally without goin to each cell and change
the formula to have site 'XYZ'.

Thanks in advance,

Shashi