Hi NJ,

You have a reading in B6 of the main spreadsheet and you collect data
from another spreadsheet, you transfer the data to the main spreadsheet
and want to compare the two pieces of data. would something like this
work?

=b6-'C:\Documents and
Settings\Larry\Desktop\[10.28.05.xls]Sheet1'!$B$6


Larry


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=488374