View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
franklin85 franklin85 is offline
external usenet poster
 
Posts: 1
Default Macro to produce Hyperlinks

Hello people,

I have a query regarding hyperlinks. I have a summary page of around 90
organisations, each of which has its own tab within the work book.

I was wondering if there was a macro or something which would save me having
to go through the list of organisations one by one and creating a hyperlink
individually to its related sheet. The organisation names all are the same
as thier related tab name within the work book.

Many thanks for your help

Franklin85