Changing a cell referent in a formula several at a time...

  • Thread starter Thread starter johnexcel
  • Start date Start date
J

johnexcel

I have a workbook with 10 worksheets all which I use a fomrula that
references a page called data. How can I change a cell reference linked
to another page on several same type formulas without having to go to
each formula and change that specific reference to a cell? For example,
the formula now reads =IF(+data!B16=3,C16,"") and I now want all the
formulas to reference the column a in place of b instead?
=IF(+data!A6=3,C16,"") do I have to do this individually ? Any help
greatly appreciated...
JE
 
Back
Top