• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

praneethone

New Member
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
 

Attachments

  • Summary.xlsx
    10.6 KB · Views: 9
  • Branch A.xlsx
    23.1 KB · Views: 12
  • Branch B.xlsx
    22.7 KB · Views: 9
Hi,

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

Attachments

  • Summary.xlsm
    21.6 KB · Views: 13
Back
Top