+ Reply to Thread
Results 1 to 3 of 3

Automatically adding new rows with formula

  1. #1
    Brian
    Guest

    Automatically adding new rows with formula

    I have sheet with rows and each row has formulas based on cells in that row.
    I would like to have a new row automatically inserted with the formulas
    updating to reference the cells in the new row. Let's say I start with 50
    rows and after they are filled up, a new row is added automatically? How do I
    do this?

  2. #2
    Brian
    Guest

    RE: Automatically adding new rows with formula

    I also have checkboxes that reference a cell in each of it's corresponding
    row. How can I autofill checkboxes and update the cell it reference's?

    "Brian" wrote:

    > I have sheet with rows and each row has formulas based on cells in that row.
    > I would like to have a new row automatically inserted with the formulas
    > updating to reference the cells in the new row. Let's say I start with 50
    > rows and after they are filled up, a new row is added automatically? How do I
    > do this?


  3. #3
    Norman Jones
    Guest

    Re: Automatically adding new rows with formula

    Hi Brian,

    Visit David McRitchie at:

    http://www.mvps.org/dmcritchie/excel/insrtrow.htm

    About 30 lines down,. look for David's InsertRowsAndFillFormulas macro which
    should satisfy your requirements.

    ---
    Regards,
    Norman



    "Brian" <Brian@discussions.microsoft.com> wrote in message
    news:878E9643-4635-425C-A125-51B2A62DE9FB@microsoft.com...
    >I have sheet with rows and each row has formulas based on cells in that
    >row.
    > I would like to have a new row automatically inserted with the formulas
    > updating to reference the cells in the new row. Let's say I start with 50
    > rows and after they are filled up, a new row is added automatically? How
    > do I
    > do this?




+ 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