Actuall I just read that you wanted a single cell
Well:
you can use this formula:

=IF(GP7<"",GP7,"")

use function:


IF
logical test = CLICK on cell in other workbook TYPE: <""
Value if true= CLICK on cell in other workbook
Value if false= TYPE: ""



this will then automatically update whenever the cell changes


--
ufo_pilot
------------------------------------------------------------------------
ufo_pilot's Profile: http://www.excelforum.com/member.php...o&userid=25972
View this thread: http://www.excelforum.com/showthread...hreadid=477500