=OFFSET(Sheet2!A$1,(ROW(A1)-1)/6,) and copy into your cells 6 rows apart.
--
David Biddulph

"Picman" wrote in message
...
I have a column of cells that import there values from another worksheet
with
simple formula;
=sheet2!a1
=sheet2!a2
=sheet2!a3, etc.

The problem is that these cells are 6 rows apart and the reference data on
"sheet 2" is in a column with no spaces. If it were only a couple of
entries
i would do it manualy but there are about 4500 of them. i was hoping to
use
an "indirect" function but i don't seem to be able to copy the formula and
have the cell reference progress down the list, it copies the same cell
reference into all copied cells.