+ Reply to Thread
Results 1 to 4 of 4

Function button does not copy formule & text.

  1. #1
    Registered User
    Join Date
    06-16-2021
    Location
    Netherlands
    MS-Off Ver
    2105 (build 14026.20270)
    Posts
    7

    Question Function button does not copy formule & text.

    Welcome to my thread!

    Hey Guys, I am busy with making a schedule for my company.
    I added a function button that adds a new row and copies the formula to it. The problem is that it does not
    copy everything I would like to. (text in K&L and formula in O)
    Does anyone know whats the matter?

    I would be really glad if someone could help me out!

    Thank you in advance,

    Szymon
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Function button does not copy formule & text.

    Why not just use Structured tables?

    When you start a new row of data, the formulas get copied down automatically
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    06-16-2021
    Location
    Netherlands
    MS-Off Ver
    2105 (build 14026.20270)
    Posts
    7

    Re: Function button does not copy formule & text.

    Quote Originally Posted by FDibbins View Post
    Why not just use Structured tables?

    When you start a new row of data, the formulas get copied down automatically

    Hey There,

    Thank you for your answer. I am already using Structured tables. It copies most of the formulas to the next row, but still forgets Column 9,10 and 13.
    I dont know what could be causing that.

    If you have any idea, I would be really glad.

    greetings,

    Szymon

  4. #4
    Registered User
    Join Date
    06-16-2021
    Location
    Netherlands
    MS-Off Ver
    2105 (build 14026.20270)
    Posts
    7

    Re: Function button does not copy formule & text.

    Hey There! problem solved. I forgot to link the formule with the [(at)column].
    First few times I got the overflow error but happend to be i forgot the (at) in my formula.
    Topic solved!

+ 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. Copy integer from a range with formule
    By Vladi108mb in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-15-2020, 11:10 AM
  2. Need formule for a text look-up
    By Robert1311 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-30-2019, 04:05 PM
  3. [SOLVED] Button to copy text WITHOUT using VBA/Macros
    By aglawrence in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-14-2018, 02:28 PM
  4. Button to copy specific cells to another sheet, lock button if cell has text
    By elmerg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2014, 02:10 AM
  5. =sheet function keeps disappearing in formule
    By drgogo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2011, 05:41 AM
  6. Looking for sumif formule or function
    By stoltzs1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-26-2010, 07:41 AM
  7. Replies: 2
    Last Post: 08-16-2009, 04:33 PM

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