Closed Thread
Results 1 to 5 of 5

Formula updating when rows are added on other sheet

  1. #1
    Forum Contributor
    Join Date
    07-05-2012
    Location
    Stockholm
    MS-Off Ver
    Excel 2010
    Posts
    162

    Formula updating when rows are added on other sheet

    Hello,
    I want to know if it is possible for a formula to be updated when new rows are added on another sheet at the end of the rows included in the formula.

    Attached example: If I add a row in Sheet1 under row 6, I want the formula in Sheet2 (cell B2) to update to
    Please Login or Register  to view this content.
    , but at the moment it stays as
    Please Login or Register  to view this content.
    Any ideas?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Formula updating when rows are added on other sheet

    http://www.excelforum.com/excel-gene...09#post3167409

    Rude.
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

  3. #3
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Formula updating when rows are added on other sheet

    Not only is this a duplicate, but you've done it before.
    http://www.excelforum.com/excel-gene...ther-cell.html

  4. #4
    Forum Contributor
    Join Date
    07-05-2012
    Location
    Stockholm
    MS-Off Ver
    Excel 2010
    Posts
    162

    Re: Formula updating when rows are added on other sheet

    I don't appreciate your attitude. This was, just as the last time, only a mistake. There was some kind of database timeout, so the thread was added twice by mistake. I will remove this or set it as solved.

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Formula updating when rows are added on other sheet

    I'll close this one for you
    Josie

    if at first you don't succeed try doing it the way your wife told you to

Closed 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