Quote Originally Posted by FDibbins View Post
See if this will get tou started...

=INDIRECT("'Full Survey'!C"&ROW(A1)*27)

(you may need to fiddle with ROW(A1)
Thanks...not sure what it relates to though? is A1 relating to B3 or the Full Survey Tab?