|
How to automaticly duplicate / copy a Hyperlink WITHOUT cut and pa
Say I have a hyperlink in Cell B2 I want to make a copy of that cell in B10
How would I do this.. If I just use the formula of =B2 in cell B10 it just shows the name of the and NOT creating something that will allow me to click on it. (I am actually doing this across pages in same workbook, but the concept should be the same. Any help would be appreciated |
How to automaticly duplicate / copy a Hyperlink WITHOUT cut andpa
On Dec 1, 3:12 pm, Chromis wrote:
Say I have a hyperlink in Cell B2 I want to make a copy of that cell in B10 How would I do this.. If I just use the formula of =B2 in cell B10 it just shows the name of the and NOT creating something that will allow me to click on it. (I am actually doing this across pages in same workbook, but the concept should be the same. Any help would be appreciated Select cell B2 by holding the left button until the hand turns to a cross then copy the cell and paste it anywhere you wish. You should have a copy of the original link. regards BigD |
How to automaticly duplicate / copy a Hyperlink WITHOUT cut an
Sorry, I was wanting to do it without cutting and pasting.. I have been
cutting and pasting several hundred hyperlinks at about 100 or so at a time. I need the raw data (including URLs on 1 page) I also want to work that raw data with some caluculations on another sheet. on that other sheet, I would also like the URLs.. The problem is, depending on sorting and custom filters, I cannot just Cut and Paste the hundreds of URLS over as they will not match anymore. So I would like it to be done automaticly, so I dont have to search and find urls one at a time and cut and paste them over. "BIG D" wrote: On Dec 1, 3:12 pm, Chromis wrote: Say I have a hyperlink in Cell B2 I want to make a copy of that cell in B10 How would I do this.. If I just use the formula of =B2 in cell B10 it just shows the name of the and NOT creating something that will allow me to click on it. (I am actually doing this across pages in same workbook, but the concept should be the same. Any help would be appreciated Select cell B2 by holding the left button until the hand turns to a cross then copy the cell and paste it anywhere you wish. You should have a copy of the original link. regards BigD |
How to automaticly duplicate / copy a Hyperlink WITHOUT cut and pa
Sub copyhyperlinks()'if simple
Range("c24:c26").Copy Range("f24:f26") 'or a one liner between sheets sheets("sheet1").Range("c24:c26").Copy sheets("sheet2").Range("f24:f26") End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Chromis" wrote in message ... Say I have a hyperlink in Cell B2 I want to make a copy of that cell in B10 How would I do this.. If I just use the formula of =B2 in cell B10 it just shows the name of the and NOT creating something that will allow me to click on it. (I am actually doing this across pages in same workbook, but the concept should be the same. Any help would be appreciated |
How to automaticly duplicate / copy a Hyperlink WITHOUT cut an
Thank you for taking the time to answer my question, however, I am not sure
what to do with your answer.. I have opened Visual Basic for my first time today, and I think that what you have above, needs to go in there. If not where on the spreadsheet does this go? thank you. "Don Guillett" wrote: Sub copyhyperlinks()'if simple Range("c24:c26").Copy Range("f24:f26") 'or a one liner between sheets sheets("sheet1").Range("c24:c26").Copy sheets("sheet2").Range("f24:f26") End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Chromis" wrote in message ... Say I have a hyperlink in Cell B2 I want to make a copy of that cell in B10 How would I do this.. If I just use the formula of =B2 in cell B10 it just shows the name of the and NOT creating something that will allow me to click on it. (I am actually doing this across pages in same workbook, but the concept should be the same. Any help would be appreciated |
How to automaticly duplicate / copy a Hyperlink WITHOUT cut an
Don,
Thank you very much, it works perfectly. Does exactly what I needed it to do. Also, Thank you Mr McRitchie for the great website.. I will need to look in there alot more closely. "Don Guillett" wrote: If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Don Guillett Microsoft MVP Excel SalesAid Software "Chromis" wrote in message ... Thank you for taking the time to answer my question, however, I am not sure what to do with your answer.. I have opened Visual Basic for my first time today, and I think that what you have above, needs to go in there. If not where on the spreadsheet does this go? thank you. "Don Guillett" wrote: Sub copyhyperlinks()'if simple Range("c24:c26").Copy Range("f24:f26") 'or a one liner between sheets sheets("sheet1").Range("c24:c26").Copy sheets("sheet2").Range("f24:f26") End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Chromis" wrote in message ... Say I have a hyperlink in Cell B2 I want to make a copy of that cell in B10 How would I do this.. If I just use the formula of =B2 in cell B10 it just shows the name of the and NOT creating something that will allow me to click on it. (I am actually doing this across pages in same workbook, but the concept should be the same. Any help would be appreciated |
How to automaticly duplicate / copy a Hyperlink WITHOUT cut an
Glad to help. Aren't you glad you worked on some of it by yourself.
-- Don Guillett Microsoft MVP Excel SalesAid Software "Chromis" wrote in message ... Don, Thank you very much, it works perfectly. Does exactly what I needed it to do. Also, Thank you Mr McRitchie for the great website.. I will need to look in there alot more closely. "Don Guillett" wrote: If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Don Guillett Microsoft MVP Excel SalesAid Software "Chromis" wrote in message ... Thank you for taking the time to answer my question, however, I am not sure what to do with your answer.. I have opened Visual Basic for my first time today, and I think that what you have above, needs to go in there. If not where on the spreadsheet does this go? thank you. "Don Guillett" wrote: Sub copyhyperlinks()'if simple Range("c24:c26").Copy Range("f24:f26") 'or a one liner between sheets sheets("sheet1").Range("c24:c26").Copy sheets("sheet2").Range("f24:f26") End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Chromis" wrote in message ... Say I have a hyperlink in Cell B2 I want to make a copy of that cell in B10 How would I do this.. If I just use the formula of =B2 in cell B10 it just shows the name of the and NOT creating something that will allow me to click on it. (I am actually doing this across pages in same workbook, but the concept should be the same. Any help would be appreciated |
| All times are GMT +1. The time now is 02:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com