I know how to setup a dynamic range. However, I need a set of formula that'll
allow the dynamic range to always use the last 10 rows on data in that range.
My current set of formula is
"=OFFSET(Yearly!$CX$2,0,0,COUNTA(Yearly!$CX:$CX),1 )". It allows me to use the
entire range, but I only need the last 10 rows. Please help!Thanks