Excell question about formula copying!!!
 

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

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.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Excell question about formula copying!!!" <Excell question about formula
wrote in message
...
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...).