Question: how to copy hyperlink from one sheet to another in excel?
Answer: Select the information to be copied and press Ctrl+C. ...  Switch to Excel and select the cell where you want the link to appear. Click the down-arrow under the Paste option on the Home tab of the ribbon and then click Paste Special. ...  Choose Hyperlink from the list of options. ...  Click OK.