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?
I'm using Excel 2019.
Great! To insert data with a hyperlink from one cell into another sheet in the same workbook, you'll need to use the hyperlink formula. First, select the cell where you want the new information to appear. Then, type "=" followed by the cell reference of the cell containing the hyperlink. For example, if your hyperlink is in cell "A1" of the "Sheet1" worksheet, you would type "=Sheet1!A1". This will display the hyperlink in the new cell.