Is auto hyperlinking possible?
 

I have a workbook set up with 50 sheets numbered 1 to 50. I cut and
paste data into columns A & B. Column A will contain numbers in random
order from 1 - 50 (but not necessarily all the numbers). At the moment
I have a front cover sheet with hyperlinking to the sheets.

Is it possible that the numbers pasted in column A can be 'auto
hyperlinked' to their corresponding sheets?

Thanks for any ideas

Rob


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=490270