View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Confused at Work Confused at Work is offline
external usenet poster
 
Posts: 26
Default Hyperlink Formula

I have 300 different sheets on one workbook and they all go to a seperate
worksheet diferent parts of it. Instead of hyperlinking one specific one at
ta time, after I do one is there anyway I can copy them and they will update
automatically they are all the same distance apart on each sheet. Example,
g30 then g60. THey are like 40 cells apart.