Here is a little trick:

Say your list is in H1 thru H40 and in D1 you have your typical Data
Validation pull-down. In another cell (say D2) enter:

=IF(1=2,HYPERLINK("",""),D1)

Obviously 1 does not equal 2 so the dummy hyperlink is never returned. D1
is always returned. Excel will put a real, click-able, link in D2 cell
--
Gary''s Student
gsnu200701


"RBeau" wrote:

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