I am automating an excel based report and need a formula that will take cell
A2 with its
hyperlink from Sheet2 and copy it to another column in Sheet 1. Hyperlink points to external web address. When I use just
=A2 it copies the text but without the hyperlink.
How to do this? Thank you for your help