assuming one cell for each team on sheet 2 contains your assigned value
number, which updates as scores come in, just refer to those cells in
sheet 1. As games are played, the values on sheet 2 will change, and
sheet 1 will automatically update. I hope this is not fantasy football
:-)


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=548543