+ Reply to Thread
Results 1 to 2 of 2

Insert result into a table as data changes

  1. #1
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Australia
    MS-Off Ver
    Excel 365
    Posts
    125

    Insert result into a table as data changes

    Hi all.

    I'm sure this will be solved easily by one of the clever people here.

    Cells B5 and C5 are the variables. As data is input I need the "Running Total" table to update.

    So for example if C5 is changed to 23, C13 would become 23 also.

    If Apples gets changed to Pears at B5, cell C16 would update when C5 is changed.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Insert result into a table as data changes

    Try this macro

    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below

+ 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. VBA to insert data in formula, then copy paste the result
    By Voggy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-20-2017, 12:04 PM
  2. Reverse Data - Find data and return result in a new table
    By Caswa7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2016, 10:21 AM
  3. how to automaticly insert mising data in excel table from other table
    By migors in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-05-2015, 06:18 AM
  4. Replies: 5
    Last Post: 09-23-2013, 05:06 PM
  5. Data Table producing inconsistent result
    By Dinsy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-04-2013, 12:38 PM
  6. Replies: 1
    Last Post: 09-13-2012, 07:30 PM
  7. Need to add data to table in result sheets
    By humacdeep in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-20-2012, 05:57 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