View Single Post
  #3   Report Post  
Ron Coderre
 
Posts: n/a
Default

Actually, this also works:
=OFFSET(Sheet2$A$1,ROW(A1)/2,0)
(Enter formula in Sheet1!A1 and copy to A3, A4, etc)

--
Regards,
Ron