Excell question about formula copying!!!

[Guest]

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...).

 

[Max]

One way .. Try something along these lines ..

Suppose you have

In Sheet1
------------
In A1: =Sheet2!A1

And you want to copy A1 to A5, A9 .. to return as:
(i.e. in every 4th cell down .. note the correction in cell refs)

In A5: =Sheet2!A2
In A9: =Sheet2!A3
etc

Put instead in A1:
=OFFSET(Sheet2!$A$1,INT((ROWS($A$1:A1)-1)/4),)

Right-click on A1 > Copy

While holding down the CTRL key,
select the cells A5, A9, A13, etc
Right-click > paste

The above will return what you're after in A5, A9, A13, etc

Just adjust the "4" in the rows param part
in the OFFSET formula: ... INT((ROWS($A$1:A1)-1)/4)
to say "3" if you want it in every 3rd cell down. And so on.