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

[venkyonly]

Hi Dear,

Plz Excel Macros help

I need to replace in master file previous data with current status data using macros vba code.


I have two files which is one is master file & one daily dump file with this I need to repalce with dump file in master file.


Example: In master file i have order number , status & date,

in dump i have old order number & new order number , new status & new .

I need to replace daily with dump file in master file.

Please help me soon.

thanks in advance

Regards
venky