vba code for automating branch wise day wise amount to summary file

[praneethone]

Hi All,

I need a vba code in excel to automate branch wise day wise amount to summary file in month wise sub sheets against particular date. If any day has no amount in branch file it has to be updated in summary file as zero. I can do this with formulas but it is tedious to do for 200 and above files. Macro to be run once i input Branch Code in sub sheets in Summary file.

Please find requirement files for details.

Your cooperation in this regard highly appreciated.

praneeth

 

[Deepak]

Hi,

Check with attached file, branch wise xl file need to be in same folder.