Hyperlink to URL

[Portucale]

Hi,

I have a list of ID numbers which corresponds to specific web pages within our system, what I am trying to do is have the users to click in one cell with a number and do to the URL.
The URL is
https://skyiq.service-now.com/nav_to.do?uri=u_work_requests.do?sysparm_query=number=WR0027519
When I put it directly on the browser it takes me to the right place, but as a Hyperlink in excel takes me to the home page.

Any help is very much appreciated,

Thanks,

 

[Luke M]

Can you post the formula you are using? What is the exact contents of the cell? If is just a number, or does it have the WR prefix?

 

[Portucale]

Can you post the formula you are using? What is the exact contents of the cell? If is just a number, or does it have the WR prefix?

Hi Luke,
The cell references will always be similar to the one in the sample "WR0012345", the formula I am using is around,
=Hyperlink("
https://skyiq.service-now.com/nav_to.do?uri=u_work_requests.do?sysparm_query=number=&A2", "Go")
But hope to write a macro, cause can be more than 500 records at a time.
Thanks for the help

 

[Portucale]

Thanks for all the help, issue as far formula is concerned seems to be resolved

=HYPERLINK("https://skyiq.service-now.com/nav_to.do?uri=u_work_requests.do?sysparm_query=number="&A2,"Go") where A2 is reference (WR0012345)

Now just looking for a macro function

Any help is very much appreciated,

 

[Luke M]

What exactly would the macro do? Open up 500 different tabs/windows navigating to the item? (not sarcastic, truly curious as to what you want the macro to do)

 

[Portucale]

What exactly would the macro do? Open up 500 different tabs/windows navigating to the item? (not sarcastic, truly curious as to what you want the macro to do)

Hi Luke,

Me and do not think... no no macro is needed I just have them in my mind at the moment , doing to many things at the same time.