I am attempting to use Paste Special, Paste Link to get a portion of one
worksheet linked to another. The source data is a mixture of data types,
some cells are text, some are dates and some are numerical.
Upon completing the Paste Link process, many of the cells contain 0, some
have a date 1/0/00. Reformatting doesnt seem to help, and the number of
cells is quite large which makes this impractical, in any event.
I can not determine why the cell formatting is not coming over properly.
Any suggestions will be helpful.
Marsh