"Fran McConville" wrote
Oh...if only it were that simple Max! That certainly works within a
worksheet, and within a workbook from one sheet to another,

But on the face of it, doesn't that cover what was described in your
original question ?

but it doesn't work from one workbook to another. Don't ask me why!!

If the source Sheet1 were in another book, say Book4.xls, then with
Book4.xls open, the formula in Sheet2's A1 would look something like

: =[Book4]Sheet1!A1

And we could just copy across to link the entire row in the same way
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----