workbook to workbook
 

In a cell in workbook no.1 I have this eneterd No.8-CRP-B1,
in a cell in workbook no.2 in A7 i want to link this cells so it reads
the same and will update when updated. so I opened bolth notebooks when
into workbook no.2 and cell A7 entered = and then highlighted the cell
in workbook no.1 for some reason I get the response #value why is this?
when I do this with other cells I have no problem? Thanks for the help.


--
MIKE0W
------------------------------------------------------------------------
MIKE0W's Profile: http://www.excelforum.com/member.php...o&userid=21465
View this thread: http://www.excelforum.com/showthread...hreadid=379762