+ Reply to Thread
Results 1 to 2 of 2

[SOLVED] Inserting rows and having the formula follow

  1. #1
    workofiction
    Guest

    [SOLVED] Inserting rows and having the formula follow

    I have the formula =SUM(I2:I190/F2:F190) which works wonderfully. Only
    problem is that when I go to insert a new row, the formula won't follow down
    that column without draggin it from the cell above... any way to do this
    automatically?
    Thanks in Advance!

  2. #2
    Peo Sjoblom
    Guest

    RE: Inserting rows and having the formula follow

    With a macro

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


    Regards,

    Peo Sjoblom

    "workofiction" wrote:

    > I have the formula =SUM(I2:I190/F2:F190) which works wonderfully. Only
    > problem is that when I go to insert a new row, the formula won't follow down
    > that column without draggin it from the cell above... any way to do this
    > automatically?
    > Thanks in Advance!


+ 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