Plz help me for Automation using excel macros, Need to add new updates in master file with daily report

[venkyonly]

Hi Dear,


Please help me for automation using excel macros.


I am spending so much time to prepare master file using vlookup & some more functions. But i need help to auto update by opening master file with daily dump file.

In my master file i have fixed columns are Order numbers , order status, EDD date with these columns i want to add respective new status & new EDD from daily dump file.

Help me for automation using VBA code.

Example columns:

My Master file columns like this:

order number current status EDD date new status new EDD date
1234 shipping 1 April 2014 add from daily dump file add from dump file
3457 dispatched 30 July 2014 add from daily dump file add from dump file
6789 order placed 8 aug 2014 add from daily dump file add from dump file


My daily dump life:

order number new status new EDD date
3560 dispatched 4 aug 2014
3607 dispatched 27 July 2014
3157 dispatched 19 sep 2014


please send me need urgently

thank you so much in advance


Regards
venky