Is it typically better to have a separate sheet for calculations or is it better to have everything on one sheet with the formula rows hidden? I am working on a workbook that will contain 12 separate sheets (for each month) and each sheet requires a whole set of calculations. The preliminary version of this was more than 25 sheets long. To simplify, and not deal with Sheet Name reference issues, is it just easier to do all the calculations on each monthly sheet and just hide them away?
Bookmarks