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:
Bookmarks