+ Reply to Thread
Results 1 to 4 of 4

Average workbook on one master worksheet

  1. #1
    Registered User
    Join Date
    04-17-2013
    Location
    Dekalb, IL
    MS-Off Ver
    Excel 2010
    Posts
    9

    Average workbook on one master worksheet

    I cannot figure out how to manipulate the macro code. I have a few lines that display data from other worksheets onto a master worksheet. I would like to add a line that will average B43:B44 on each sheet and list them individually at Cells(i, 4). Would you please help me write that line into the below code?

    Please Login or Register  to view this content.
    Thank you!

    Moderators note: code tags added for you - this time
    Last edited by FDibbins; 04-18-2013 at 04:00 PM. Reason: code tags added

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Average workbook on one master worksheet

    Hi and welcome to the forum

    Please use code tags when posting VBA code (ee my notes below on how to)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    04-17-2013
    Location
    Dekalb, IL
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Average workbook on one master worksheet

    FDibbins I am not sure what instructions you are referencing to post in VBA code. I am new to macro and I appreciate any help I can get!

  4. #4
    Registered User
    Join Date
    04-17-2013
    Location
    Dekalb, IL
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Average workbook on one master worksheet

    Bump no response.

+ Reply to Thread

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