I have a wrong Formula in a workbook that contain 18 worksheets. The wrong formula is:
=SUM((D12<C12)+D12-C12+(F12<E12)+F12-E12+(I12<H12)+I12-H12)*24
Is there a easy way of using find and replace this formula in each worksheet with :=SUM((D12<C12)+D12-C12+(G12<E12)+G12-E12+(I12<H12)+I12-H12)*24
Of coure the row number will change because the formula is in at least 30 rows on each sheet?
=SUM((D12<C12)+D12-C12+(F12<E12)+F12-E12+(I12<H12)+I12-H12)*24
Is there a easy way of using find and replace this formula in each worksheet with :=SUM((D12<C12)+D12-C12+(G12<E12)+G12-E12+(I12<H12)+I12-H12)*24
Of coure the row number will change because the formula is in at least 30 rows on each sheet?