You need to create a macro linked to the worksheet_change event of your
first sheet which will then lookup the value in the second sheet and
then use a file open such as

Open "C:\sgdkjagsd.txt" For Input As #1
Do while not EOF(1)
Line input #1, FileLine
Cells(65536,1).end(xlup).offset(1,0) = FileLine
Loop

Close #1


--
mrice


------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533614