I have two sheets names source.xlsx and master.xlsx.

1) i need to find whether values in source.xls into master.xlsx by using vlookup.

2) if found i need to find the values in master.xlsx and paste the values in column in which user has to specify. ex. if i want to paste the values in column named 15/06/2012 then i need to specify the value as 15/06/2012.

3) once the above process the done, then i need to check for the entries which are not available in the master file. Copy all the NA in source sheet and paste the same in master.xlsx after the last used cell in column A and fill the values as stated in step2.

Can this be done using macros. Kindly assist.