Soldato
- Joined
- 6 Jan 2013
- Posts
- 22,309
- Location
- Rollergirl
We have a spreadsheet that works out percentages, and this is the correct formula which is in column B for every row. In this example, we're looking at row 86.
Somehow, all the formula from row 90 onward have got messed up, the 88 should be 90:
The problem is repeated all the way down to row 285. I could manually correct the forumla but it's going to take a while. Is there a simple fix to save me doing it manually - like how the format painter does all the conditional formatting?
Code:
=A86-(SUM(F86:QH86))Somehow, all the formula from row 90 onward have got messed up, the 88 should be 90:
Code:
=A90-(SUM(F88:QH88))The problem is repeated all the way down to row 285. I could manually correct the forumla but it's going to take a while. Is there a simple fix to save me doing it manually - like how the format painter does all the conditional formatting?
