actually one followup question...
is there a way to make the
"=OFFSET(Sheet1!$B$3,0,0,COUNTA(Sheet1!$B:$B), 1)" formula work when the
field that calculates the rest actually sits in the same column, on top,
in field B1 to be specific?
--
pelachrum
------------------------------------------------------------------------
pelachrum's Profile:
http://www.excelforum.com/member.php...o&userid=35962
View this thread:
http://www.excelforum.com/showthread...hreadid=557594