Link multiple cells

D

David C

I have to link a range of cells between two work books. Is there a way to do this without entering links into each individual cells, i.e. link the whole lot at once?
 
E

Edmund Seet

If I read u correctly, here's one way:

1. Select range at source, then Edit>Copy.
2. Select target, then Edit>Paste Special>Paste Link.

HTH
Edmund Seet
 
Top