I have a workbook with lots of formulas and sheets. It is updated weekly and the data grows irregularly with every update. As of right now I have my formulas referencing entire columns in order to capture all new data. This is starting to catch up with me, as the processing time is detracting from the intended use of this file
I'm curious if there is an easy way to use something like named ranges that I can easily update, or automatically update to use in these formulas.
Manually updating all ranges every week opens up the possibility that I could miss something and send out bad info.
Do you think that eliminating these full column formulas will have a noticeable effect on the performance?
Thank you!
-Nlarski
I'm curious if there is an easy way to use something like named ranges that I can easily update, or automatically update to use in these formulas.
Manually updating all ranges every week opens up the possibility that I could miss something and send out bad info.
Do you think that eliminating these full column formulas will have a noticeable effect on the performance?
Thank you!
-Nlarski