+ Reply to Thread
Results 1 to 2 of 2

Running total

  1. #1
    Registered User
    Join Date
    05-22-2011
    Location
    gonzales la
    MS-Off Ver
    Excel 2007
    Posts
    1

    Angry Running total

    I have a spreadsheet ranges from a-m lines 5-44. line 22 is a sum adding lines 5-21 and subtracting lines 23-44. at midnight each night we clear all info entered in the addition and subtraction ranges. how do i get the total to stay at what it is at midnight to carry over to the next day after deleting previous days entry's?

    in addition we can only have this one spreadsheet. multiple sheets are out.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Running total

    You can copy and paste special as values.
    Entia non sunt multiplicanda sine necessitate

+ 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