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.