+ Reply to Thread
Results 1 to 4 of 4

assistance to adjust code to sum on their specific worksheets in vba

  1. 06-05-2017, 03:16 PM #1
    JEAN1972
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    assistance to adjust code to sum on their specific worksheets in vba

    The two code below makes a total of specific columns when their respective sheet is active

    Worksheet Summary Report and Worksheet Workings.

    How to make the code works with their respective sheets without being on the active sheet that is if I create macro button on another sheet, It calls the macro to sum on their respective worksheets

    Worksheet Summary Report (macro (sub totalreport)

    Please Login or Register  to view this content.
    tab named Workings( macro codeSub totalWorkings()

    Please Login or Register  to view this content.
    Last edited by JEAN1972; 06-05-2017 at 03:29 PM.
    Reply With QuoteRegister To Reply
  2. 06-05-2017, 03:29 PM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: assistance to adjust code to sum on their specific worksheets in vba

    I think all you'd need is to add the sheet name

    Please Login or Register  to view this content.
    For both sheets of course. Hope I understood your request correctly.
    Reply With QuoteRegister To Reply
  3. 06-05-2017, 03:41 PM #3
    JEAN1972
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    Re: assistance to adjust code to sum on their specific worksheets in vba

    thanks you John

    Worked
    Reply With QuoteRegister To Reply
  4. 06-05-2017, 04:00 PM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: assistance to adjust code to sum on their specific worksheets in vba

    You're welcome. Glad to help out and thanks for the feedback and reps.
    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. [SOLVED] VBA code assistance with saving all worksheets except 4 as PDF with cell value as name
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-12-2016, 02:32 PM
  2. How to adjust VBA code to create rule for a specific cell, rather than a whole column
    By jlax87 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-20-2015, 12:51 AM
  3. [SOLVED] Adjust Code to Sort by specific Cell characters found with cell
    By boldcode in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-15-2014, 02:34 PM
  4. VBA code(?) to take out specific formulas in all worksheets
    By thomas.mapua in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2013, 12:09 PM
  5. [SOLVED] Help edit this code so that it loops through specific worksheets
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-18-2012, 05:35 AM
  6. Assistance with Creating a Specific Macro using VBA code
    By Pbeer in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-17-2008, 05:35 AM
  7. Using Code to Adjust Specific Column Width
    By Nigel Bennett in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-09-2005, 03:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1