I am trying to use cell references as part of a link but it fails.
This is the actual link
='\\Fsmel01\fireworks\6- Quality\Business Division Quality\Technical Support\Caribbean\Michael Colvin\Call Quality\April 05\Business Division Technical Support Quality Scorecard Blank.xls'!IDYes
This is what I am trying to acheive
='\\Fsmel01\fireworks\6- Quality\Business Division Quality\Technical Support\[B]&Team\&b27&\Call Quality\&AL17&\Business Division Technical Support Quality Scorecard Blank.xls'!IDYes
So I want the cell references to refer to the link. I have use &...& in the linked cel line but it fails
Please help.
Thanks in advance
Bookmarks