When an auto fill is applied to three cell containing the entries:

=Sheet1!C303, =Sheet1!C318, =Sheet1!C333,

Noting that the intended pattern is a simple linear pattern, increasing row
number by 15 each time.

These are the resulting auto fill entries:

=Sheet1!C303, =Sheet1!C318, =Sheet1!C333, =Sheet1!C306, =Sheet1!C321,
=Sheet1!C336.

How do I get the auto fill function to follow the obvious €œprevious row
number +15€� pattern?


Thanks,
Chris

try:

=INDIRECT("Sheet1!C"& (ROW()-ROW($A$1))*15+30)

assuming you start in row 1. Change $A$1 to starting row.

"Kiwi Chris" wrote:

When an auto fill is applied to three cell containing the entries:

=Sheet1!C303, =Sheet1!C318, =Sheet1!C333,

Noting that the intended pattern is a simple linear pattern, increasing row
number by 15 each time.

These are the resulting auto fill entries:

=Sheet1!C303, =Sheet1!C318, =Sheet1!C333, =Sheet1!C306, =Sheet1!C321,
=Sheet1!C336.

How do I get the auto fill function to follow the obvious €œprevious row
number +15€� pattern?


Thanks,
Chris

Try =INDIRECT("Sheet1!C"&303+(ROW(A1)-1)*15) in first cell, then drag down
column to copy
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Kiwi Chris" <Kiwi wrote in message
...
When an auto fill is applied to three cell containing the entries:

=Sheet1!C303, =Sheet1!C318, =Sheet1!C333,

Noting that the intended pattern is a simple linear pattern, increasing
row
number by 15 each time.

These are the resulting auto fill entries:

=Sheet1!C303, =Sheet1!C318, =Sheet1!C333, =Sheet1!C306, =Sheet1!C321,
=Sheet1!C336.

How do I get the auto fill function to follow the obvious "previous row
number +15" pattern?


Thanks,
Chris

In microsoft.public.excel.misc on Wed, 8 Aug 2007, Toppers
wrote :
try:

=INDIRECT("Sheet1!C"& (ROW()-ROW($A$1))*15+30)

assuming you start in row 1. Change $A$1 to starting row.

'Indirect' - yet another function I've never heard of! :)
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)