Results 1 to 13 of 13

Automatically move a formula line down when new data is added

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-20-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007, Excel 2003, Excel 2010
    Posts
    284

    Automatically move a formula line down when new data is added

    Hello:

    I have data in A1 to A10 and used the following =SUM(A$1:A10) formula in A12 to sum the data and keep summing new data that might be added. Is there a way to automatically keep moving A12 down one row as new data is added. When I manually add a new row the sum is updated and accounts for the new data but i am trying to find a way for it to automatically move down since the data in the sheet will be autopopulated so i would need it to move down by however many new rows are added.

    Thanks
    Last edited by rlsublime; 11-22-2011 at 04:47 PM.

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