Thank you Pete_UK,

Final question, will this (or a variation of it) also work if the referenced
cells (from the second workbook) are all located on the same sheet in the
second work book.

Thanks again and sorry for the bother...

v/r,

Steve



"Pete_UK" wrote:

Something like this, for example?:

=IF('full_path[filename2.xls]Sheet1'!
A1<"",'full_path[filename2.xls]Sheet1'!
A1,IF('full_path[filename2.xls]Sheet2'!
A1<"",'full_path[filename2.xls]Sheet2'!
A1,IF('full_path[filename2.xls]Sheet3'!
A1<"",'full_path[filename2.xls]Sheet3'!
A1,'full_path[filename2.xls]Sheet4'!A1)))

Put this in your "one" cell, and it will bring data from A1 of either
Sheet1, Sheet2, Sheet3 or Sheet4 of filename2.xls, whichever is not
blank.

Hope this helps.

Pete

On Aug 28, 3:38 pm, Shek5150
wrote:
Greetings...

I would like to know if there is a way to link a single cell from one work
sheet to several cells from another worksheet (from a different workbook)..
Kind of like a one-to-many relationship; however, on the many side, only one
of the several cells in this second workbook would have data at a time and
it would be this data that would migrate to my main workbook on the "One"
side of the relationship.

Hope that mades sense...

v/r,

Steve