Changing a formula on the worksheet
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
|