Excel drag and fill

[SamG1990]

Hi I’m trying to drag and fill and range of cells to add one to a cell from another sheet.

Cell A1 =DATES!E6
Cell B1 =DATES!E6+1
Cell C1 =DATES!E6+2
Etc

But when I drag and fill it is increasing the cell reference rather than the increment.

Any help would be appreciated

 

[Scott T]

You need to make the cell reference an absolute reference so it will not change. You can use columns as an incrementor. in A1 then copy across.

=dates!$E$6+COLUMNS($A$1:A1)-1