|
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? |
hyperlink to website and then to information in a certain cell
Use the Hyperlink function
With the number in A1 you can use =HYPERLINK("http://fs.xxx-xxxx.com/cgi-bin/fieldsup/getRemedy_isd.cgi?ticknum=" & A1) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ernie" <Ernie @discussions.microsoft.com wrote in message ... 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? |
hyperlink to website and then to information in a certain cell
The link has always worked when I put the number in after ticknum=.
But, I have thousands of ticket numbers daily on a spread sheet that I look at and I do not want to manually enter this for every one of them. ("http://fs.xxx-xxxx.com/cgi-bin/fieldsup/getRemedy_isd.cgi?ticknum=I NEED A FORMULA HERE THAT WILL IDENTIFY THE CONTENTS OF THE CELL, WHICH THE CONTENTS ARE EACH INDIVIDUAL TICKET NUMBER. I would like to be able to just click this cell (which has the ticket number in it) and it take me to the web page. Otherwise I have to put the number in the hyperlink for every cell. "Ron de Bruin" wrote: Use the Hyperlink function With the number in A1 you can use =HYPERLINK("http://fs.xxx-xxxx.com/cgi-bin/fieldsup/getRemedy_isd.cgi?ticknum=" & A1) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ernie" <Ernie @discussions.microsoft.com wrote in message ... 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? . |
hyperlink to website and then to information in a certain cell
Why are you shouting (Caps)? People here are not employees of MS that get
paid answering questions and to do other people's work. People answering questions do it on voluntary basis. Bear that in mind! -- Regards, Peo Sjoblom "Ernie" wrote in message ... The link has always worked when I put the number in after ticknum=. But, I have thousands of ticket numbers daily on a spread sheet that I look at and I do not want to manually enter this for every one of them. ("http://fs.xxx-xxxx.com/cgi-bin/fieldsup/getRemedy_isd.cgi?ticknum=I NEED A FORMULA HERE THAT WILL IDENTIFY THE CONTENTS OF THE CELL, WHICH THE CONTENTS ARE EACH INDIVIDUAL TICKET NUMBER. I would like to be able to just click this cell (which has the ticket number in it) and it take me to the web page. Otherwise I have to put the number in the hyperlink for every cell. "Ron de Bruin" wrote: Use the Hyperlink function With the number in A1 you can use =HYPERLINK("http://fs.xxx-xxxx.com/cgi-bin/fieldsup/getRemedy_isd.cgi?ticknum=" & A1) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ernie" <Ernie @discussions.microsoft.com wrote in message ... 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? . |
hyperlink to website and then to information in a certain cell
Have you test the formula with the number in A1 ?
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ernie" wrote in message ... The link has always worked when I put the number in after ticknum=. But, I have thousands of ticket numbers daily on a spread sheet that I look at and I do not want to manually enter this for every one of them. ("http://fs.xxx-xxxx.com/cgi-bin/fieldsup/getRemedy_isd.cgi?ticknum=I NEED A FORMULA HERE THAT WILL IDENTIFY THE CONTENTS OF THE CELL, WHICH THE CONTENTS ARE EACH INDIVIDUAL TICKET NUMBER. I would like to be able to just click this cell (which has the ticket number in it) and it take me to the web page. Otherwise I have to put the number in the hyperlink for every cell. "Ron de Bruin" wrote: Use the Hyperlink function With the number in A1 you can use =HYPERLINK("http://fs.xxx-xxxx.com/cgi-bin/fieldsup/getRemedy_isd.cgi?ticknum=" & A1) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ernie" <Ernie @discussions.microsoft.com wrote in message ... 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? . |
hyperlink to website and then to information in a certain cell
Not shouting in no means Sir, was just making sure they could recognize
where I need a formula. And caps does not always mean you are shouting, can be used to make sure something is not over looked. Bear that in mind! "Peo Sjoblom" wrote: Why are you shouting (Caps)? People here are not employees of MS that get paid answering questions and to do other people's work. People answering questions do it on voluntary basis. Bear that in mind! -- Regards, Peo Sjoblom "Ernie" wrote in message ... The link has always worked when I put the number in after ticknum=. But, I have thousands of ticket numbers daily on a spread sheet that I look at and I do not want to manually enter this for every one of them. ("http://fs.xxx-xxxx.com/cgi-bin/fieldsup/getRemedy_isd.cgi?ticknum=I NEED A FORMULA HERE THAT WILL IDENTIFY THE CONTENTS OF THE CELL, WHICH THE CONTENTS ARE EACH INDIVIDUAL TICKET NUMBER. I would like to be able to just click this cell (which has the ticket number in it) and it take me to the web page. Otherwise I have to put the number in the hyperlink for every cell. "Ron de Bruin" wrote: Use the Hyperlink function With the number in A1 you can use =HYPERLINK("http://fs.xxx-xxxx.com/cgi-bin/fieldsup/getRemedy_isd.cgi?ticknum=" & A1) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ernie" <Ernie @discussions.microsoft.com wrote in message ... 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? . . |
| All times are GMT +1. The time now is 08:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com