The conversation between human and AI assistant.
Excel: How to insert data from one cell (with hyperlink to another cell), into another cell, in another sheet, but same workbook, when activated?
Ok, I've done that. What's the next step?
Next, you'll need to press "Enter" to confirm the formula. The hyperlink will now appear in the new cell. When you click on the hyperlink, it will take you to the original cell in the original worksheet. If you want to insert not just the hyperlink but also the data from the original cell, you can use the "INDEX" formula instead.