G
Guest
I would like to have a hyperlink that changes depending on what text is in a
cell.
If cell A1 says 1234, the hyperlink would be:
\\Common\Engineering\SPO-SPP\SPO-1234
If cell A1 says 2468, the hyperlink would be:
\\Common\Engineering\SPO-SPP\SPO-2468
How do I get cell A1 into the hyperlink?
cell.
If cell A1 says 1234, the hyperlink would be:
\\Common\Engineering\SPO-SPP\SPO-1234
If cell A1 says 2468, the hyperlink would be:
\\Common\Engineering\SPO-SPP\SPO-2468
How do I get cell A1 into the hyperlink?