Hello,

Just want to check if there is another way of writing the below formula

=OFFSET(Source!$F$1,1,0,COUNTA(Source!$F$2:$F$27),1)
It actually works, however, the downside of the formula is that I need to manually select/adjust the Column F if there are more than 27 lines.