I normally avert from macros for several reasons but I'm wondering if it is capable of helping me in this case. I have document that takes a long time to open and process even the smallest change. Is it possible and would it be more efficient to program formulas into the necessary cells via macro? If so, what kind of strategy would one use to go about programing formulas into specific cells?
For practicallities sake, I have attached a small portion of what the main sheet that has all the formulas. Can someone please lead me in a direction of how to go about populating this LOB sheet. Thank you.
-The sheet is called LOB. The formulas here pull data from the other sheets in the workbook
-There are 3 items listed, however there will be about 3500 items in the final version.
-The cells I'm considering programming are highlighted in light blue. These cell formulas don't change; they are the same for every item on the list. I just use a script to paste them down the whole sheet for the amount of items needed.
-The LOB sheet has conditional formatting, etc.
-I'm not sure but the formulas that might be slowing things down the most might be the sumproduct formula that is in row 5.
Any help/thoughts/direction is appreciated.
Bookmarks