Copy + paste formula/formulas every Nth row with moving references

Hi guys,

I won't be able to do this without the help of this forum. I'm trying to come up with something I haven't tried before, and I would be extremely happy if this worked out. This example shows me that I need to learn VBA!

I attached the file - maybe seeing example will tell more, than what I will be writing. But nevertheless, here it goes...

I'm trying to create a big database that will be getting its' inputs from tabs that I will be inserting on a daily basis.
But there are around 300 items and for every item there are few indicators.
Basically, what I need is to copy paste formulas every nth row. Just like there are formulas from B5:E5 I need to paste it every 10th row - B15:E15, B25:E25 etc.,..

I would appreciate a macro for this with some basic explanation, because I would like to modify it later for other rows - I will have to copy paste formulas for all 7 rows highlighted in blue.

This is going to be a life saver guys!!!
I'd appreciate help very much!

vemix

Hi Vemix,

Follow the below steps:

Place the cusor on the first formulas that is B5:E5 and run the below macros

Sub Paste_Macro()
Selection.Copy
ActiveCell.Offset(10, 0).Select
ActiveSheet.Paste
End Sub

Hope it tunes fine for you.

Regards,
KK