Thank you for your reply, however it is not working for me. I must be
doing something wrong, just don't know what. I have created a target
workbook to act as a compilation of other workbooks. I clicked on a
target cell in a worksheet with an equal (=) sign, then went to the
workbook that I am pulling that data from, clicked on the desired cell
and all it did was advance to the next lower cell in the pull from
worksheet. I went back to the target workbook and it still showed an
equal (=) sign, as if I hadn't done anything else. ??????????????? What
now?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=566286