• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

copy Hyperlinks from a cell in 1st workbook to another cell in the 2nd workbook

R

rahulshewale1

Active Member
hiii everyone,,,,

how to copy Hyperlinks from a cell in 1st worksheet to another worksheet. i am getting error i am trying copy and paste.
 

Attachments

  • error.png
    error.png
    11.9 KB · Views: 7
Hi ,

The word HYPERLINK can refer to different things ; if you can upload a workbook , do so ; if not , explain what you mean by HYPERLINK , is it the function or is it a manually entered hyperlink ?

If it is a formula using the HYPERLINK function , please post the formula ; if it is a manually entered hyperlink , post a screenshot of what the hyperlink is referring to.

Narayan
 
Dear Narayan,

thanks for help.I created hyperlink using Shortkey Ctrl+K in 1st worksheet. hyperlink is working properly but i am trying copy and paste hyperlink another worksheet i am getting error.is it possible copy and paste.
 
Hi ,

There is no problem in copying and pasting ; if you post a screenshot of what the hyperlink is referring to , it may be clear.

I created a hyperlink on Sheet1 , referring to Sheet3!A1 ; copying and pasting this to Sheet2 inserted the hyperlink in Sheet2 without any problem.

Narayan
 
You must log in or register to reply here.
Back
Top