Autofilling of formula for every 5th row

[jasme]

Hello,

Can somebody please help in running a auto filling of highlighted formula for rebalancing after every fifth row for eight years daily data which I cannot do manually. Which way would be easiest macro coding or is there any simplest way?
I am new to coding for macros in excel.
Please find my sample spread sheet attached.

Appreciate the help in advance.

Thanks,
Jasme

[p24leclerc]

Hi Jasme, try the following code.
It copies the row where you have all the formula every 5 rows down. The only drawback, it does not the last copy at the end of the sheet. You'll have to do it manually.
I also attached file with the macro.
Pierre
P.S. as you had reference to another workbook in your formula, I'm not sure how it will show on the attached file. Make sure your formula are OK. Be better to create the procedure in your original file, though.

Please Login or Register  to view this content.