Question: how to paste link from one excel sheet to another?
Answer: Copy the data you want to transpose and link, as you normally would. Select any cell in an unused worksheet. Choose Paste Special from the Edit menu. ...  Click on the Paste Link button. ...  Press Ctrl+H to display the Replace dialog box. ...  In the Find What area, type an equal sign.