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
|