Hello,
I've tried the code. I have replaced the workbook name (master data)
and sheet name and I am getting an error with the following two codes
below:

1.If WorksheetFunction.Countif(Workbooks("Management Information
System_2005").Sheets("Raw Data").Columns(1),
_Workbooks("wkbk1").Sheets("NewStuff").Cells(rw1,1 ))= 0 Then

2.rw2
=worksheetfunction.Match(Workbooks("wkbk1").Sheets ("NewStuff").Cells(rw1,1),_Workbooks("wkbk2").Shee ts("OldStuff").Columns(1),0)


Also, if a new entry in the new data is missing in the master file,
what should be the correct code that I should use to add a new line in
the master file and put all the values in the new line


--
lalthan
------------------------------------------------------------------------
lalthan's Profile: http://www.excelforum.com/member.php...o&userid=10557
View this thread: http://www.excelforum.com/showthread...hreadid=397222