Is auto hyperlinking possible?

B

Brisbane Rob

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
 
Top