| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink to secure website | Excel Discussion (Misc queries) | |||
| Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
| Logging a website information. | Excel Worksheet Functions | |||
| how do i upload and save information off a website | Excel Worksheet Functions | |||
| from Excel look up customer information on a website | Excel Worksheet Functions | |||
![Ernie[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
