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

Great.... Thanks.
"Rafael Ortiz" wrote in message
...
Toggle the sheet to Formula View (CTRL + `), then do an Edit, Replace...
Then toggle back to regular view (CTRL + `)

Note: The ` is on the same key as the tilde (~).

MRO


"Shashi Bhosale" wrote in message
...
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