+ Reply to Thread
Results 1 to 4 of 4

Table copying formulas but not copying value

  1. 04-27-2014, 03:28 AM #1
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Table copying formulas but not copying value

    hello
    i have created a table. when i m editing new row then formulas is copying bu value is not copying ?

    plz help
    Reply With QuoteRegister To Reply
  2. 04-27-2014, 03:30 AM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Table copying formulas but not copying value

    In a table the formula is copied.

    The formula gives a (new) result, so of course the value is not copied.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 04-27-2014, 03:33 AM #3
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Table copying formulas but not copying value

    hello oeldere

    how to copy value ?
    Reply With QuoteRegister To Reply
  4. 04-27-2014, 03:45 AM #4
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Table copying formulas but not copying value

    haroon2015

    you have > 500 post!!!

    copy => paste special

    or show us the excelfile.


    Added
    And another question.

    What is the formula that's in the table.
    Last edited by oeldere; 04-27-2014 at 04:01 AM. Reason: added (see question)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using vba to add row to a table but formulas are not copying down from the line above
    By pjdumont in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2013, 03:00 AM
  2. [SOLVED] Formulas are not copying after converting a Table to a Range
    By johnw993 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-22-2013, 12:39 AM
  3. Copying pivot table formulas to another worksheet so the worksheet is dynamic and will upd
    By ccbank in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 12-06-2012, 01:48 PM
  4. [SOLVED] Copying a table with formulas
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 05-20-2012, 11:33 AM
  5. Table question - only some formulas copying down
    By hektisk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-01-2011, 09:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1