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

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

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

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

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

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

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

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