Reference same cell every nth row?

[rlexcel101]

Hey all new here great forum..

Need some help with formula.

I am referencing same value from another tab in same workbook and I want to drag the formula down but only include the fixed value in every 4th row. I tried OFFSET and ROW but it seems to not be working.

 

[rlexcel101]

I was solving a different problem... Where you had moving data in another workbook and wanted to bring it in to the destination.
Instead you have a single data point that you want to bring in every 4th cell, a simpler problem, pending an answer:

What do you want in R9, R10, R11?

in R8, enter the following formula: =IF(MOD(ROW(8:8),4)=0,sourcedata!$A$5,"")

This worked!!!

Thank you so much