+ Reply to Thread
Results 1 to 3 of 3

Automatic Cell update

  1. #1
    Registered User
    Join Date
    05-01-2018
    Location
    United States
    MS-Off Ver
    360
    Posts
    2

    Automatic Cell update

    I know by the title this sounds simple, and if its possible in excel it probably is, however I am trying to have a cell output a cumulative total. For instance lets say the output cell is A5. I have Cell A4 be the number that I want added to cell A5, but want the output to still be Cell A5. To make it simpler say the previous value of cell A5 was 5, and cell A4 is 0. I want to be able to change A4 to 10 and have cell A5 automatically change to 15. Any help would be greatly appreciated. Thank you.

  2. #2
    Registered User
    Join Date
    05-01-2018
    Location
    United States
    MS-Off Ver
    360
    Posts
    2

    Re: Automatic Cell update

    I found a solution, it was very simple, had to change a setting in my preferences to allow iterations. If others have this issue, the link I used was support.office.com/en-us/article/remove-or-allow-a-circular-reference-8540bd0f-6e97-4483-bcf7-1b49cd50d123. Apparently I didn't look hard enough.

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Automatic Cell update

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. live automatic cell update based on another cell
    By bong14 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-12-2015, 11:33 PM
  2. [SOLVED] Automatic update of cell values not working.....
    By tnuis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2013, 05:09 PM
  3. [SOLVED] Automatic update of a cell every time another one is changed
    By Romoluzzi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2013, 09:52 AM
  4. Automatic date update in a cell when another cell's value changes (as calculated
    By vinwin06 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2013, 12:22 PM
  5. Replies: 8
    Last Post: 05-02-2012, 10:35 PM
  6. automatic update for cell in worksheet using vba doesnt want to display value
    By st0kvis in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-18-2011, 03:08 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