I have an application that pulls data into cells from other cells based upon
selection from a drop down box. The original data has some information that
is hyperlinked (URL). This works fine except that when the data is copied,
the hyperlink is lost.

Is there some way to ensure that the hyperlink is retained?

Thanks for any assistance .. greatly appreciated