I'm trying to link between a group of cells on one worksheet to group of
cells in second worksheet. The first group of cells have either a hyperlink
or text. When I simply copy over the first group to the second as linked
cells, the hyperlinks don't always work on the second sheet. When I copy the
cells over and keep source formatting the hyperlinks work, but of course
aren't linked now. What do I need to do to get consistently active
hyperlinks in the destination linked cell?