Change formula across many sheets at the same time
If (and only if) you have used the concepts of best practice, you can access a tool which allows you to make mass changes to your spreadsheet, both with text and formulas.
In the example below we see two different sheets that are structurally the same (note that Product X and Y are in the same rows, the 31 Dec 2003’s are in the same column, the client name is in cell A1 on both sheets).
If we want to make changes to both at the same time, all you need to do is….
To see the full course contents click here.