[Greg Maxey]

There is another way. Copy the source cell text and paste special
paste as link in the destination cell. This creates an OLE link in the
destination cell to the source cell.

Very similiar to the REF method, but not as labor intensive.



Stephan Laska wrote:
"Greg Maxey" wrote in message
oups.com...
If your values are numerical you would use {=Sum(source A2)}

ah, so I need to use SUM even though I am only "summing" one cell.

If the values are text you would need to create bookmarks for each cell
in the source table and used REF fields in the destination table.


yikes! too much work! lol