In cell F2 of a sheet named "main flash" I want to have it display the
following:

"for week 42 ending"

The week 42 part would come from another sheet named "actuals" that's
in the same workbook.


--
Weasel
------------------------------------------------------------------------
Weasel's Profile: http://www.excelforum.com/member.php...o&userid=27206
View this thread: http://www.excelforum.com/showthread...hreadid=525683