+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

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

    Hi All,

    I have a requirement in excel for automating branch wise day wise amount to summary file month wise day wise. The summary file has month wise sub sheets. I need vba code to run for all the months once i input Branch code in Summary file month wise sub sheets.
    If any day amount is not mentioned in source file the same has to be updated in summary file for that particular date as zero.

    I am attaching requirement files for reference.

    Your cooperation in this regard highly appreciated.

    Sincerely,
    Pranith
    Attached Files Attached Files
    Last edited by pranithpm; 07-19-2014 at 04:17 AM. Reason: forgot to attach files

  2. #2
    Forum Contributor
    Join Date
    06-24-2005
    Location
    excelliot.com
    MS-Off Ver
    2007
    Posts
    325

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

    There is no attachments!!

    You can get it done thru Pivot Table too.

    Cheers!!

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,293

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

    Hi, and welcome to the forum.

    No file is attached, however consider putting all your data that's currently on separate monthly sheets onto a single sheet that contains an additional column for the date, and then use a Pivot Table.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

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

    The is no excel file attached.

    I advice you to put all data (of all months) in 1 sheet.

    After that you can use a pivot table to analyze your data.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. sum by month wise and staff wise horizontal and vertical
    By cjjimmy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2014, 04:07 AM
  2. Excel code to represent data from row wise to column wise
    By sreejeshc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-12-2013, 03:45 AM
  3. [SOLVED] I want change the data row wise to coloum wise & coloumn wise to row wise.
    By satputenandkumar0 in forum Excel General
    Replies: 3
    Last Post: 12-20-2012, 08:34 AM
  4. [SOLVED] Data row wise, formula column wise
    By Fred Smith in forum Excel General
    Replies: 4
    Last Post: 12-09-2005, 11:55 AM
  5. [SOLVED] Delete row wise duplicates & colomun wise simultaneously excel
    By Dipankar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-06-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1