Hi

Just don't get the solution:

I have done what you suggetsed but how will that change a 100 odd
formulas ?

just so that we are on the same page.

=IF('[Quality Scorecard Test.xls]Jan'!B2="","",'[Quality Scorecard
Test.xls]Jan'!B2)
=IF('[Quality Scorecard Test.xls]Jan'!B3="","",'[Quality Scorecard
Test.xls]Jan'!B3)
=IF('[Quality Scorecard Test.xls]Jan'!B4="","",'[Quality Scorecard
Test.xls]Jan'!B4)
=IF('[Quality Scorecard Test.xls]Jan'!B5="","",'[Quality Scorecard
Test.xls]Jan'!B5)
=IF('[Quality Scorecard Test.xls]Jan'!B6="","",'[Quality Scorecard
Test.xls]Jan'!B6)
=IF('[Quality Scorecard Test.xls]Jan'!B7="","",'[Quality Scorecard
Test.xls]Jan'!B7)

This is just a small snapshot of over 100 formulas in varios cells.

I need the name of the link worksheet to chnage from what it currently
is to whatever is selected in b2 (That is B2 on the current worksheet
not the one above. The formalua above contains the information needed
for this worksheet.

Am I just not getting it or are we on a different page?


--
Mikeice
------------------------------------------------------------------------
Mikeice's Profile: http://www.excelforum.com/member.php...o&userid=22467
View this thread: http://www.excelforum.com/showthread...hreadid=378266