Autofill reference series

[Rick]

How can I make the following cell reference drag and fill up to B66
='F20 survey'!$B7
='F20 survey'!$B8
='F20 survey'!$B9
....
='F20 survey'!$B66

When I autofill or drag and fill it only paste/fills the 1st three over and
over

 

[Luke M]

Only select 1 cell when you do your drag. Otherwise, XL thinks you want to
copy that particular pattern.

 

[Luke M]

Ugh need coffee...ignore earlier post. Your formula should be copying
correctly. Make sure the cells aren't formatted as text, and that could cause
issues. Also, is calculation mode set to automatic, or manual?

 

[Rick]

Cells are formatted to number. It does not sequence up on the row number.
It holds the column with $, but selecting the 1st cell in the series and
dragging only paste the previous cell. If I make the 1st 3 cells sequence up
like I want (='F20 survey'!$B7; ='F20 survey'!$B8, ='F20 survey'!$B9) then
try to drag, it copy and paste those cells over and over