Macro to paste formulas then paste values

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!

Send me an example file with expected output in it, so that I can make sure about your request since your above explanation is making some confusion....

Abdul

Hi Abdul,

I have attached an example model that will explain what I need. So the macro will copy the formulas from the blue block into the purple block, once its done the calculations, the purple block must be copied and pasted as values over itself.

hope this clarifies my problem.

Use this file....

That doesn't seem to work. All the macro does is copy one array to other as values. However i managed to record a macro that does what i need. Thank you for the help.