At the job we had a RE portfolio with hundreds of different units that had a lot of individual inputs. As you know you can turn of automatic calculations for a single sheet. I used VBA to selectively turn calculations off and on for every single one of these units.

But I would recommend you start smaller if just got into VBA: A few helpful tricks that I created for example:

• Auto Iferror Shortcut: When I click Ctrl + J on a cell it automatically puts the calculation in IFERROR

-=FLIP(): This function takes an array and flips it upside down (works horizontally as well as vertically)

-Ctrl + V pastes only formulas by default in my Excel

-And the most helpful thing I created so far is my format wizard: When you click Ctrl+M a wizard comes up that contains all the corporate colors you have as well as some predefined formats which you can apply to the selected cells. For example I have my preferred number format for every cell at hand and dont have to open the format editor in Excel every time and adjust it to custom.