+ Reply to Thread
Results 1 to 2 of 2

Keeping formula in table after inserting new rows

  1. #1
    Registered User
    Join Date
    07-29-2020
    Location
    Kansas, USA
    MS-Off Ver
    Up-To-Date
    Posts
    1

    Keeping formula in table after inserting new rows

    I have a userform that inputs information into a table, and the table will add a row at the bottom every time something is entered. I also have a column in the table that uses a formula but when I enter new data and the end of the table the formula does not fill down. Is there a way to do this that will keep the formula when inserting a new row at the bottom?

  2. #2
    Registered User
    Join Date
    05-14-2020
    Location
    Mauritius
    MS-Off Ver
    Office 365
    Posts
    97

    Re: Keeping formula in table after inserting new rows

    Hello,

    use the function for formatted table. This will take all formatting and formulas into the next row automatically.
    Highlight your complete table, menu Insert - Table, tick or untick the option for headers. Ready.
    Greetings

    Tor


+ 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. [SOLVED] SOLVED! copying rows and inserting them while keeping formulas/formatting by vba
    By Fredvonny in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-17-2020, 02:12 PM
  2. [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
  3. [SOLVED] Keeping formula the same when inserting a row
    By coach.32 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-04-2016, 08:34 AM
  4. inserting a row then keeping a formula in it
    By ollielow1993 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2013, 08:43 AM
  5. Keeping cell reference the same after inserting rows
    By muadebe in forum Excel General
    Replies: 6
    Last Post: 08-27-2012, 12:43 PM
  6. Inserting rows whilst keeping filter range.
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2010, 09:44 AM
  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

Tags for this Thread

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