Hey everyone,
I need a macro that will copy a row of formulas (at the top of my spreadsheet) down to the rows beneath, will then do the calculations and then copy and paste those formulas as values (the top row must obviously stay as formulas). The reason I want to do this is because the formulas contain dynamic ranges and are slowing down the model. Pasting them as values solves the speed problem but then the model itself becomes static.
Thank you for the help!
Bookmarks