+ Reply to Thread
Results 1 to 6 of 6

Excel novice needing assistance with cumulative totals

  1. #1
    Registered User
    Join Date
    03-12-2014
    Location
    texas
    MS-Off Ver
    Excel 2003
    Posts
    3

    Excel novice needing assistance with cumulative totals

    I have a spreadsheet I use at work to keep running totals of hours equipment is used. My problem is we have to hand write this information and take information from other employees sheets. On several occasions we have added extra hours due to poor penmanship. I have attempted to make this spreadsheet so that we are able to just input our shift hours and the totals are kept. My issue is a code I found on this forum some time ago, not sure who the user was or I would love to give credit. I am only able to get the code to work in one cell and I need the daily totals to go into multiple cells. I think the work sheet is self explanatory. The workbook I need assistance with is under the machinery report tab. Any help would be greatly appreciated. If this can be done I would be willing to pay towards completion of this task.
    Attached Files Attached Files
    Last edited by jlwhitten; 04-09-2014 at 04:01 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Excel novice needing assistance with cumulative totals

    Hi jlwhitten

    Welcome to the forum.

    You give us (well me, at least!) far too much credit when you say that " the work sheet is self explanatory". I can see what it is used for, but I do not understand where a formula is going to help. In particular I cannot see which cell on the Daily Report that needs to go to "multiple cells"

    Does the Machinery Report have the details of the last occurrence of the items in E22 - E38 and these get carried forward until they show when the next happening is due?

    Perhaps if you were to give a worked example, someone will be able to assist.

    Regards
    Alastair

  3. #3
    Registered User
    Join Date
    03-12-2014
    Location
    texas
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel novice needing assistance with cumulative totals

    Alastair , thanks for your reply due to the lack of replies I took my question to another forum. The problem is solved and the worksheet is doing just what I needed. Again thanks for your attempted help. It was a simple code adjustment that I was not able to figure out. This thread should be closed

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

    Re: Excel novice needing assistance with cumulative totals

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    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]

  5. #5
    Registered User
    Join Date
    03-12-2014
    Location
    texas
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel novice needing assistance with cumulative totals

    I am not a programmer so I couldn't begin to describe what was done. Someone was kind enough to write a code that did what I needed. Here it is.

    Please Login or Register  to view this content.
    Hope I did this right.

  6. #6
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Excel novice needing assistance with cumulative totals

    Hi jlwhitten

    Yes, you did it right. Now all you have to do to tidy things up is to mark the thread as Solved. You can do this by going to your first posting - there is an option there to mark it solved.

    Glad you found an answer.

    Regards
    Alastair

+ 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] How to get cumulative totals from weekly totals (IE sum of all previous cells)?
    By moeburn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-08-2013, 07:29 PM
  2. Novice with VBA and macro writing needing help to loop a macro unti no data
    By jrongone in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-25-2013, 12:19 PM
  3. Newbie needing assistance
    By Woodchuck75 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-22-2012, 11:33 AM
  4. novice needing help on formula
    By jordiman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2009, 08:25 AM
  5. [SOLVED] mathematician dummy needing assistance
    By [email protected] in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-21-2005, 05:10 PM

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