copying hyperlinks to another sheet

[Guest]

My worksheet contain some datas with hyperlinks. I have to copy the hyperlink
to
another sheet or another workbook. I don't need the data in the cell. I
need hyperlinks only. How to copy hyperlinks to other sheet?

 

[Guest]

Try this:
Copy the link to the sheet and cell you want it in. With the link
highlighted in the "to" cell, Click Insert > Hyperlink then OK when the
dialog box pops up.