Thread: Links in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pb pb is offline
external usenet poster
 
Posts: 19
Default Links in Excel

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)?