+ Reply to Thread
Results 1 to 1 of 1

adjust table formulas after insert

  1. #1
    Registered User
    Join Date
    01-15-2018
    Location
    medford, oregon
    MS-Off Ver
    2010
    Posts
    21

    adjust table formulas after insert

    I am trying to figure out how to keep the formulas in series in rows in the table, after inserting new row.
    right now when inserting "new user" that row keeps formatting, but does not insert a formula, It would have to adjust the formulas below it obviously.

    example..

    =IF(C9="","",C9+1095)
    =IF(C10="","",C10+1095)
    =IF(C11="","",C11+1095)

    any help is appreciated.

    Please Login or Register  to view this content.
    Certification.xlsm
    Last edited by new guy; 09-01-2022 at 10:56 AM.

+ 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. Keeping formula in table after inserting new rows
    By SP4NKH4RD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2020, 01:50 AM
  2. Keeping a formula in a table
    By dillon240 in forum Excel General
    Replies: 4
    Last Post: 07-15-2019, 11:55 PM
  3. [SOLVED] Keeping formula the same when you insert a row
    By brose99 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-16-2018, 10:38 PM
  4. [SOLVED] Extend currnt table whilst keeping the Formula (Create a live league table)
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-14-2018, 02:11 PM
  5. Replies: 1
    Last Post: 09-07-2011, 05:25 AM
  6. Using Insert and keeping formula
    By insanity66 in forum Excel General
    Replies: 4
    Last Post: 01-10-2007, 01:22 PM
  7. Keeping a series table from updating when adding new rows.
    By Jacen Saracen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-18-2005, 02:05 AM

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