View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rick is offline
external usenet poster
 
Posts: 334
Default 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