See also Don's suggestion.

I like it mo' better.


Gord

On Tue, 26 Aug 2008 09:33:01 -0700, Geoff
wrote:

Gord

Many thanks. This works.

I have nearly 2,000 rows so great time saver.

Geoff



"Gord Dibben" wrote:

In B1 enter =A1

In B2 enter this formula =OFFSET($A$1,6*ROW()-6,0)

Coipy down as far as you wish.


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 08:06:09 -0700, Geoff
wrote:

In a column I want the first cell to be =A1 but then the next cell to be =A7
and so on. =A1+6 doesn't work. Is there a way?