You could probably use:

=indirect("work"&row())

HTH

"shadestreet" wrote:


Well, I think I found the dealbreaker in my whole plan..

Apparently formulas that reference named cells do not automatically
update the reference if you drag the formulas down... stays fixed on
reference "work1" instead of "work2" when I drag the formula down one
notch.

Doubtful, but if there is a way around this final hurdle please let me
know.

Thanks


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=546736