AutoFill with Non-sequential Cell References ?

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@hotmail.com> wrote in message
news:42b60dae.36360603@news-server.nyc.rr.com...
> 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- 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.


"Anne Troy" <ng@officearticles.com> wrote:

>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@hotmail.com> wrote in message
>news:42b60dae.36360603@news-server.nyc.rr.com...
>> 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?
>
>

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

<moretrades@hotmail.com> wrote in message
news:42b60dae.36360603@news-server.nyc.rr.com...
> 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?

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?

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@hotmail.com> wrote in message
news:42b60dae.36360603@news-server.nyc.rr.com...
> 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- 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.


"Anne Troy" <ng@officearticles.com> wrote:

>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@hotmail.com> wrote in message
>news:42b60dae.36360603@news-server.nyc.rr.com...
>> 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?
>
>

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

<moretrades@hotmail.com> wrote in message
news:42b60dae.36360603@news-server.nyc.rr.com...
> 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?