+ Reply to Thread
Results 1 to 6 of 6

How to autofill formulas in new rows inserted by an add-in

  1. #1
    Registered User
    Join Date
    05-03-2017
    Location
    Boston, MA
    MS-Off Ver
    2016
    Posts
    21

    How to autofill formulas in new rows inserted by an add-in

    I am using the Team Foundation Add-in to bring over data from TFS. The data comes over as a table with headers. To this table, I added a few columns that contain formulas that use some of the data coming over from TFS.
    When I refresh the table, new rows are added with new data from TFS, but the cells in the columns I have added do not get auto-filled with my formula. I have to copy the formulas into the new row manually.
    I thought the auto-fill was a feature of a table with headers, so I'm not sure why this isn't working. How can I get this working?

    Thanks!

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: How to autofill formulas in new rows inserted by an add-in

    format your range as a table

  3. #3
    Registered User
    Join Date
    05-03-2017
    Location
    Boston, MA
    MS-Off Ver
    2016
    Posts
    21

    Re: How to autofill formulas in new rows inserted by an add-in

    Quote Originally Posted by tim201110 View Post
    format your range as a table
    It's already a table. When I select it, the Table button on the Insert tab is grayed out.

  4. #4
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: How to autofill formulas in new rows inserted by an add-in

    in this case you need a code initialised by worksheet event

  5. #5
    Registered User
    Join Date
    05-03-2017
    Location
    Boston, MA
    MS-Off Ver
    2016
    Posts
    21

    Re: How to autofill formulas in new rows inserted by an add-in

    Quote Originally Posted by tim201110 View Post
    in this case you need a code initialised by worksheet event
    Thanks. Is there a way to move this question to the VBA forum or do I need to create a new thread?

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,336

    Re: How to autofill formulas in new rows inserted by an add-in

    Quote Originally Posted by durna01 View Post
    Thanks. Is there a way to move this question to the VBA forum or do I need to create a new thread?
    Ask a Moderator or Administrator to do this for you. Just don't do it yourself.
    Dave

+ 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. Inserting Rows and Protected Formulas to Appear on Inserted Row
    By MatthewIJClark in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2017, 10:05 AM
  2. Inserting Rows and Protected Formulas to Appear on Inserted Row
    By MatthewIJClark in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-09-2017, 06:26 AM
  3. Autofill Formulas On New inserted row
    By achishti in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-08-2014, 02:59 AM
  4. Error when copying formulas down inserted rows
    By LAF in forum Excel General
    Replies: 1
    Last Post: 12-30-2009, 05:33 PM
  5. Keeping formulas in inserted rows
    By bbvcbob in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2007, 05:36 AM
  6. Extend Formulas to Inserted Rows
    By AC in forum Excel General
    Replies: 2
    Last Post: 07-19-2006, 05:30 PM
  7. Can array formulas work if rows are inserted?
    By Chris in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2006, 11:35 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