Paste Link
I have created a worksheet in Excel 03. I am trying to link a large number
of the cells to another worksheet in the same workbook. When I use Paste
Link to link 1 cell only I get an absolute reference ($). When I try to link
numerous cells at once - I get the exclamation mark (!)and the cell rederence
(ie !D4). Then if I add rows and re-sort the source worksheet - the
destination will no longer contain the proper referenced links.
Question - how do I Paste Link for a block of cells and still maintain an
absolute reference so that I can change the Source and be confident that the
Destination Worksheet will be properly changed as well?
--
Many thanks,
Pud
|