The COUNTA portion of the formula counts the number of cells in the column (F) containing data. If there are empty cells above F8, this is the part of the formula to change.
Assuming empty cells above F8 I'd try this
=OFFSET(Sheet2!A1,COUNTA(Sheet2!F:F)+7,5)
Catharine (aka WebGenii)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.