grinfactor
New Member
- Joined
- Jan 22, 2015
- Messages
- 3
Hi all,
I hope that someone can help me with this..
1. I have long list of URL addresses that I want to have displayed on a random basis. I only have space for 5 at a time
2. In column A of sheet 1, I manually input the URL addresses on a regular basis (these are news items so needs to be kept up to date)
3. In Column B I have entered =RAND() for all cells that have a corresponding URL address
4. On Sheet 2 (main display sheet) I want to display the random list of 5 URL's. I have used :
=HYPERLINK(INDEX('Data Breach'!$A$1:$A$6,RANK('Data Breach'!B1,'Data Breach'!B1:B6)))
5. This works fine, but it displays the URL address which is to long for the cell in Sheet 2
6. I want to use a 'friendly name' for each of the the URL's that has a hyperlink to the URL, so the user can double click the cell in sheet 2 when displayed and get take to the relevant address
7. I know I can do this with a normal hyperlink as I already have a link for specific reports that has a friendly name assigned, but these reports are fixed and not random:
=IFERROR(HYPERLINK(INDIRECT("'collateral'!C"&SMALL(Collateral!A:A,1)),"Report 1"),"")
7. I've tried to embed the url into a friendly name (on sheet 1 column A) but when it shows on sheet 2 it says it 'cannot open specified file'. Had this problem before
8. Can some let me know if what I am after is possible in Excel, dont want to use VBA/Macro's if possible as I have no experience of using these
Thanks
Grinfactor
I hope that someone can help me with this..
1. I have long list of URL addresses that I want to have displayed on a random basis. I only have space for 5 at a time
2. In column A of sheet 1, I manually input the URL addresses on a regular basis (these are news items so needs to be kept up to date)
3. In Column B I have entered =RAND() for all cells that have a corresponding URL address
4. On Sheet 2 (main display sheet) I want to display the random list of 5 URL's. I have used :
=HYPERLINK(INDEX('Data Breach'!$A$1:$A$6,RANK('Data Breach'!B1,'Data Breach'!B1:B6)))
5. This works fine, but it displays the URL address which is to long for the cell in Sheet 2
6. I want to use a 'friendly name' for each of the the URL's that has a hyperlink to the URL, so the user can double click the cell in sheet 2 when displayed and get take to the relevant address
7. I know I can do this with a normal hyperlink as I already have a link for specific reports that has a friendly name assigned, but these reports are fixed and not random:
=IFERROR(HYPERLINK(INDIRECT("'collateral'!C"&SMALL(Collateral!A:A,1)),"Report 1"),"")
7. I've tried to embed the url into a friendly name (on sheet 1 column A) but when it shows on sheet 2 it says it 'cannot open specified file'. Had this problem before
![smile.gif](/board/proxy.php?image=http%3A%2F%2Fwww.excelforum.com%2Fimages%2Fsmilies%2Fsmile.gif&hash=2b23f960121a0ec03857d042b98d59dc)
8. Can some let me know if what I am after is possible in Excel, dont want to use VBA/Macro's if possible as I have no experience of using these
Thanks
Grinfactor