Well I managed to make it work but I had to set the fields to absolute
values so I used:

='W&Ww 7'!B$7

Anyone know why that would have to be?


--
MarkGG
------------------------------------------------------------------------
MarkGG's Profile: http://www.excelforum.com/member.php...o&userid=26342
View this thread: http://www.excelforum.com/showthread...hreadid=396091