+ Reply to Thread
Page 7 of 7 FirstFirst ... 5 6 7
Results 91 to 104 of 104

Macro/Code to Go Through Workbook and Build a Summary

  1. #91
    Forum Contributor
    Join Date
    07-12-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Macro/Code to Go Through Workbook and Build a Summary

    Nope, what you did there was perfect. Just an overall count of a set of Sheets created.

    Thanks.

  2. #92
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: Macro/Code to Go Through Workbook and Build a Summary

    This is your code for the summary. Had a problem with the sorting, so it took some time.
    Please Login or Register  to view this content.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #93
    Forum Contributor
    Join Date
    07-12-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Macro/Code to Go Through Workbook and Build a Summary

    I tried the code. If I copy a bunch of sheets, just to increase the number of Shore Tanks. It doubles up the Summary Again.

  4. #94
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: Macro/Code to Go Through Workbook and Build a Summary

    The macro will clear the summary page and restart, so it cant be doubling. Let me try it at my end.

  5. #95
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: Macro/Code to Go Through Workbook and Build a Summary

    To test your issue, i clicked on the Add button and created the sheets. Then i edited B61 & B60 in the new shore tank sheets. And just made a copy of the gauge tick sheet values. But those values are not showing up in the summary. Maybe i am updating the wrong sections.

    To speed it up, why dont you upload your file after adding in the extra sheets and i can troubleshoot the summary code?

  6. #96
    Forum Contributor
    Join Date
    07-12-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Macro/Code to Go Through Workbook and Build a Summary

    Will try. Sometime the file size limit gets in the way.

  7. #97
    Forum Contributor
    Join Date
    07-12-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Macro/Code to Go Through Workbook and Build a Summary

    Attachment 181304 Try this one. Just need to add the Code to the Module. I was trying a different tactic to see if I could get it to work another way for now.

  8. #98
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: Macro/Code to Go Through Workbook and Build a Summary

    I tried the code in the sheet and its showing up the same values as the previous sample file. Did you add in extra sheets?

  9. #99
    Forum Contributor
    Join Date
    07-12-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Macro/Code to Go Through Workbook and Build a Summary

    I am trying to add more Sheet, but the file becomes too large for the forums.

    If you just copy, both the gauge tic and shore tank at the same time, and then Hit the Update Summary button, thats when I got the duplicate errors again.

  10. #100
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: Macro/Code to Go Through Workbook and Build a Summary

    You can zip the file if its too huge. But let me try what you said.

  11. #101
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: Macro/Code to Go Through Workbook and Build a Summary

    Updated code -
    Please Login or Register  to view this content.

  12. #102
    Forum Contributor
    Join Date
    07-12-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Macro/Code to Go Through Workbook and Build a Summary

    That seems to have done the trick....


    Thank you very much.

  13. #103
    Forum Contributor
    Join Date
    07-12-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Macro/Code to Go Through Workbook and Build a Summary

    Solved!!!!

    Give this man a COOKIE!!!

    Excellent work.

  14. #104
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,454

    Re: Macro/Code to Go Through Workbook and Build a Summary

    @ midnightorion

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

+ Reply to Thread
Page 7 of 7 FirstFirst ... 5 6 7

Thread Information

Users Browsing this Thread

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

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