You could put this formula in your first cell:

=INDIRECT("'Orders'!"&CHAR(INT((ROW(A27)-1)/26)+64)&CHAR(MOD(ROW
(A27)-1,26)+65)&"113")

and then when you copy this down it will give you the equivalent of:

='Orders'!AA113
='Orders'!AB113
='Orders'!AC113
='Orders'!AD113
='Orders'!AE113
='Orders'!AF113

and so on.

Hope this helps.

Pete

On Jan 21, 11:32*pm, PB wrote:
I am trying to autofill a formula in an excel sheet that links to a different
worksheet.
The formula I am using is
=Orders!AA113
=Orders!AB113
=Orders!AC113
I am manually entering this because when I do an auto fill I get
=Orders!AA113
=Orders! AB114
=Orders!AC115

How do I get the auto fill function to keep the same line number (113)?