Hi All!
I would like to click on a cell in one sheet and hyperlink to a cell in another sheet based on the cell value.
Example:
Sheet 1 column A, is a range of dates. Sheet 2 column A, is also a range of unique dates in chronological order.
I would like to click on a date in Sheet 1 column A and hyperlink me to the same date in Sheet 2 column A.
Thank you!
I would like to click on a cell in one sheet and hyperlink to a cell in another sheet based on the cell value.
Example:
Sheet 1 column A, is a range of dates. Sheet 2 column A, is also a range of unique dates in chronological order.
I would like to click on a date in Sheet 1 column A and hyperlink me to the same date in Sheet 2 column A.
Thank you!
Last edited: