AutoFill with Non-sequential Cell References ?

[moretrades]

In one sheet I need to reference cells in a different sheet in the
same workbook. It's a long sheet of projections, so it would save me
lots of time if I could use AutoFill to add references to the cells on
the other sheet.

The cells I want to reference are in the same row, but they're not in
adjacent columns- specifically, they're located in every 5th. column
(i.e. A2, E2, I2, etc.) If I start with a reference to A2 and use
AutoFill, I get B2, C2, D2, etc. Is there any way to specify the
realtivity of AutoFill to use every xth. row or xth. column?

 

[Anne Troy]

Autofill generally likes 3 entries from which to "copy". So if you want
every fifth, do the first 3 entries manually, and then drag them with the
autofill.
Hope it helps!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[moretrades]

Anne Troy- I just tried and couldn't get that to work.

I'm trying to fill in a column on one work sheet- cells D4, D5, D6,
etc. with references to cells in a different worksheet on the same
row on every 4th. column- C40, G40, K40, etc.

thanks.

 

[Biff]

Hi!

If what you're try to do is this:

=A2.....=E2......=I2

Or

=A2
=A6
=A10

To reference horizontally across the row:

=OFFSET($A2,,(COLUMN(A:A)-1)*4)

To reference vertically down the column:

=OFFSET(A$2,(ROW(1:1)-1)*4,,)

Biff