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