Autofill With Custom Increment

[mkallover]

What I would like to do is figure out a way to autofill a simple formula and increment by a number other than one. For instance:

First cell: ='Source Data'!AH6
Second cell: ='Source Data'!AH12
Third cell: ='Source Data'!AH18

And so on by an increment of six. When I fill in the first two cells, select them, then autofill Excel is incrementing AH6 to AH8, AH10, etc and incrementing AH12 to AH14, AH16, etc.

There has to be a way to do this that I'm just not able to locate.

 

[AnotherHiggins]

[tab][COLOR=blue white]=INDIRECT("'Source Data'!AH" & Row()*6)[/color]

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[mkallover]

That's what I was afraid of. I'm using this Excel sheet as a data source for a Crystal Xcelsius dashboard and CX doesn't support INDIRECT.

Thanks for the help.