+ Reply to Thread
Results 1 to 19 of 19

How Can I get sum value from each workbook to one

  1. 10-14-2018, 03:28 PM #1
    jasminjakson
    jasminjakson is offline
    Registered User
    Join Date
    10-14-2018
    Location
    India
    MS-Off Ver
    2007
    Posts
    44

    How Can I get sum value from each workbook to one

    Hi Guys,
    I've spent hours searching and trying different macros with no avail. I'm not new to excel, but new to macros and coding.
    I have a lot of files need to sum data to one excel file
    Each file have data from A8:G, data need sum in column D , E , F , G
    How can I sum that by vba code? I need to put the totals in the results sheet
    Please refer attached file.
    Any help would be greatly appreciated. Thank you very much
    Last edited by jasminjakson; 10-23-2018 at 08:46 PM.
    Reply With QuoteRegister To Reply
  2. 10-15-2018, 05:09 AM #2
    jasminjakson
    jasminjakson is offline
    Registered User
    Join Date
    10-14-2018
    Location
    India
    MS-Off Ver
    2007
    Posts
    44

    Re: How Can I get sum value from each workbook to one

    Hope to find help in this topic.
    Reply With QuoteRegister To Reply
  3. 10-15-2018, 10:29 AM #3
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,815

    Re: How Can I get sum value from each workbook to one

    What is the full path to the folder containing your source files? Are the source files the only files in that folder?
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.
    Reply With QuoteRegister To Reply
  4. 10-15-2018, 08:38 PM #4
    jasminjakson
    jasminjakson is offline
    Registered User
    Join Date
    10-14-2018
    Location
    India
    MS-Off Ver
    2007
    Posts
    44

    Re: How Can I get sum value from each workbook to one

    I am so sorry for being late in reply .Thanks for your response.
    In the attachment ... Master Workbook which contains source files, and also contains the code to create many files based on column H
    How Can I get sum value from each workbook to Result sheet. through code or Perhaps there is a better way or you have other ideas to achieve that
    I am attaching the new file Please have a look
    I am weak in VBA, Please help me, I will be very grateful to you.
    note : This file by searching in this forum
    Thanks advanced for help
    Last edited by jasminjakson; 10-23-2018 at 08:45 PM.
    Reply With QuoteRegister To Reply
  5. 10-15-2018, 10:05 PM #5
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: How Can I get sum value from each workbook to one

    Quote Originally Posted by jasminjakson View Post
    Each file have data from A8:G, data need sum in column D , E , F , G
    Try
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 10-16-2018, 12:32 AM #6
    Ravisca2003
    Ravisca2003 is offline
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    Re: How Can I get sum value from each workbook to one

    Quote Originally Posted by jasminjakson View Post
    Hi Guys,
    I've spent hours searching and trying different macros with no avail. I'm not new to excel, but new to macros and coding.
    I have a lot of files need to sum data to one excel file
    Each file have data from A8:G, data need sum in column D , E , F , G
    How can I sum that by vba code? I need to put the totals in the results sheet
    Please refer attached file.
    Any help would be greatly appreciated. Thank you very much
    Hello Dear,

    Here you go.
    Please add reputation and share your experience if this help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 10-16-2018, 01:17 PM #7
    jasminjakson
    jasminjakson is offline
    Registered User
    Join Date
    10-14-2018
    Location
    India
    MS-Off Ver
    2007
    Posts
    44

    Re: How Can I get sum value from each workbook to one

    That's amazing Mr. jindon
    Except for a simple point, The master workbook should not be included in the results sheet.
    Note : I need the borders as attached in the output
    Thank you very much! I do appreciate your time and patience.
    Attached Files Attached Files
    Last edited by jasminjakson; 10-16-2018 at 01:27 PM.
    Reply With QuoteRegister To Reply
  8. 10-16-2018, 06:49 PM #8
    Ravisca2003
    Ravisca2003 is offline
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    Re: How Can I get sum value from each workbook to one

    Hi there

    Did u tried the solution i shared ??

    Regards
    Ravi
    Reply With QuoteRegister To Reply
  9. 10-16-2018, 07:51 PM #9
    jasminjakson
    jasminjakson is offline
    Registered User
    Join Date
    10-14-2018
    Location
    India
    MS-Off Ver
    2007
    Posts
    44

    Re: How Can I get sum value from each workbook to one

    Hello Friend
    Yes sure .. The same problem ...The master workbook should not be included in the results sheet.
    Regards
    jasmin
    Reply With QuoteRegister To Reply
  10. 10-16-2018, 08:40 PM #10
    Ravisca2003
    Ravisca2003 is offline
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    Re: How Can I get sum value from each workbook to one

    Quote Originally Posted by jasminjakson View Post
    Hello Friend
    Yes sure .. The same problem ...The master workbook should not be included in the results sheet.
    Regards
    jasmin
    In my code n execution, I checked only example sheets are being calculated n populated in results.xlsm file.
    Reply With QuoteRegister To Reply
  11. 10-16-2018, 08:46 PM #11
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: How Can I get sum value from each workbook to one

    Quote Originally Posted by jasminjakson View Post
    That's amazing Mr. jindon
    Except for a simple point, The master workbook should not be included in the results sheet.
    Note : I need the borders as attached in the output
    Thank you very much! I do appreciate your time and patience.
    What is "master workbook"?
    Reply With QuoteRegister To Reply
  12. 10-16-2018, 08:54 PM #12
    jasminjakson
    jasminjakson is offline
    Registered User
    Join Date
    10-14-2018
    Location
    India
    MS-Off Ver
    2007
    Posts
    44

    Re: How Can I get sum value from each workbook to one

    Please re-download the attachment in post # 4
    Last edited by jasminjakson; 10-16-2018 at 09:02 PM.
    Reply With QuoteRegister To Reply
  13. 10-16-2018, 09:01 PM #13
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: How Can I get sum value from each workbook to one

    Then perhaps
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  14. 10-16-2018, 09:15 PM #14
    jasminjakson
    jasminjakson is offline
    Registered User
    Join Date
    10-14-2018
    Location
    India
    MS-Off Ver
    2007
    Posts
    44

    Re: How Can I get sum value from each workbook to one

    That's perfect and awesome now. Thank you very much for great help and thanks a lot for your patience
    Reply With QuoteRegister To Reply
  15. 10-18-2018, 04:52 PM #15
    jasminjakson
    jasminjakson is offline
    Registered User
    Join Date
    10-14-2018
    Location
    India
    MS-Off Ver
    2007
    Posts
    44

    Re: How Can I get sum value from each workbook to one

    I am so sorry for disturbing you again Mr. jindon
    I would like to add automatic numbering before file names if possible
    Again, thanks for your kind help
    Reply With QuoteRegister To Reply
  16. 10-18-2018, 06:18 PM #16
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: How Can I get sum value from each workbook to one

    Change the heading accordingly.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  17. 10-18-2018, 07:17 PM #17
    jasminjakson
    jasminjakson is offline
    Registered User
    Join Date
    10-14-2018
    Location
    India
    MS-Off Ver
    2007
    Posts
    44

    Re: How Can I get sum value from each workbook to one

    Thanks a lot Mr. jindon for your great support all the time
    If you allow me, sir
    A final Request before posting my new topic
    I would like to sort the File names based on column B ( sort A to Z )
    My deepest appreciation. Best Regards
    Last edited by jasminjakson; 10-18-2018 at 11:34 PM.
    Reply With QuoteRegister To Reply
  18. 10-18-2018, 07:29 PM #18
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: How Can I get sum value from each workbook to one

    Change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  19. 10-18-2018, 07:47 PM #19
    jasminjakson
    jasminjakson is offline
    Registered User
    Join Date
    10-14-2018
    Location
    India
    MS-Off Ver
    2007
    Posts
    44

    Re: How Can I get sum value from each workbook to one

    Thanks a lot Mr. jindon for this wonderful and incredible help
    My deepest appreciation. Best Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Assign name to Workbook, Copy range from one workbook to another workbook
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2015, 03:40 AM
  2. [SOLVED] VBA to open new workbook and run macro from new workbook, which closes old workbook
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2014, 10:45 AM
  3. [SOLVED] Code to cut cell from one workbook, close same workbook, and paste in different workbook
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 03-13-2014, 04:01 PM
  4. Copy data one workbook to another workbook without opening workbook
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2014, 11:28 AM
  5. [SOLVED] Copy Values From Each Workbook in Folder to a Single Sheet in New Workbook +Workbook names
    By Arsham24 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2012, 07:42 PM
  6. Save an open workbook, then open template workbook and close the saved workbook
    By ondvirg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2009, 10:20 PM
  7. loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook
    By burl_rfc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2006, 03:50 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1