How do i fill non-adjacent cells with formulas, as opposed to cells that are
directly below one another? For example, I have a formula in a cell that
references a column of data from another worksheet. I want to copy that
formula to every 4th cell below it. However, when I do that, it takes every
4th data from the other sheet instead of every one (e.g. it takes A1, A4, A8
instead of A1,2,3,4...).