View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ernie[_2_] Ernie[_2_] is offline
external usenet poster
 
Posts: 1
Default hyperlink to website and then to information in a certain cell

I have a spread sheet set up with a hyper link to a web
page:http://fs.xxx-xxxx.com/cgi-bin/field...XXXXX,XXXXXXXX

the 00000XXXX represents a ticket number that I have to manually enter for
every cell in order for it to pull that ticket number up in my website.
Does anyone know what formula I can enter here that will automatically pull
the number that I have already input in the cell on my excel sheet, so that
the number will not have to be manually entered into the hyperlink for each
and every cell?