Autofill reference series
 

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

Autofill reference series
 

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

Luke M
*Remember to click "yes" if this post helped you!*


"Rick" wrote:

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

Autofill reference series
 

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?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Luke M" wrote:

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

Luke M
*Remember to click "yes" if this post helped you!*


"Rick" wrote:

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

Autofill reference series
 

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



"Luke M" wrote:

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?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Luke M" wrote:

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

Luke M
*Remember to click "yes" if this post helped you!*


"Rick" wrote:

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