+ Reply to Thread
Results 1 to 1 of 1

Expanding a Macro/Changing a Macro Help

  1. #1
    Registered User
    Join Date
    02-19-2019
    Location
    Charlotte, NC
    MS-Off Ver
    Office 2016
    Posts
    1

    Question Expanding a Macro/Changing a Macro Help

    New here, so hope someone will be able to help me out with this issue. I want to preface this post by saying, I am no Macro expert. Our company uses a Macro heavy excel timesheet for our job-site work. I was wondering if someone could provide me help or direction on how to make a change to have one section work better for us in the home office.

    Currently, we assign extras for the job (which could change job to job). We have an Estimated Weekly Invoice sheet that allows us to display total costs of these extras weekly based on inputed data. It is set up to allow you to select any of the extra and display the total for the week, but doesn't allow you to see all the extras and cost all at once. However, some of these jobs could have 10-15 Extras and being able to only view and calculate them one at a time is becoming hard for our on-site project staff to relay to our home office.

    Is there a simple fix or an additional script we could add that would allow us to add an option to view "All Extras" and them to calculate on the sheet as constructed?

    Here is an image of how we add the extras as well as the Weekly Invoice Sheet, showing the dropdown and then its calculation of that extra:

    Enter Extras for Project Here:
    Screen Shot 2019-02-19 at 3.35.05 PM.png

    Weekly Invoice: Display Job Extra #:
    Screen Shot 2019-02-19 at 3.35.27 PM.png

    When selecting one extra (in this case Standby/Delay) it will just pull that one Extra # and total and hide the rest:
    Screen Shot 2019-02-19 at 3.37.30 PM.png

    Current script from what I was able to pull reads as follows:

    Please Login or Register  to view this content.
    Last edited by 6StringJazzer; 02-19-2019 at 04:48 PM. Reason: added missing [ on code tag

+ 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. [SOLVED] Expanding macro to work based onto another cell value
    By khushboo# in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2019, 01:36 AM
  2. Accumulator Macro - working but needs expanding
    By sipa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2016, 04:59 AM
  3. [SOLVED] Expanding of a existing Macro
    By yuenk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2015, 09:38 AM
  4. [SOLVED] expanding area of effect of a macro
    By AxilRankin3 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-17-2014, 01:45 PM
  5. Expanding Search Engine in Macro Excel
    By UWS2012 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-07-2013, 05:38 PM
  6. Expanding existing macro
    By Sir08 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-29-2009, 02:52 PM
  7. Macro for copy/insert into expanding table
    By Soslowgt in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-06-2008, 07:24 PM

Tags for this Thread

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