+ Reply to Thread
Results 1 to 8 of 8

formulae not able to automatically copy down in cells in a table

  1. 12-20-2018, 01:09 AM #1
    anilpatni1234
    anilpatni1234 is offline
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    formulae not able to automatically copy down in cells in a table

    Hey guys ,
    I am stuck with a small problem.

    I have formatted a range of cells as table. So as and when i type new data in new rows, the formulaes in cells must automatically copy in the new rows.
    However some formulaes are not copying down automatically.

    In sheet PRODUCT, Column "O",and column "R" the formulae does not copy down automatically when a new row of data is added.

    example i have added a new row - refer to row 65. however the formulae in column "O" and "R" does not copy down autmatically

    Can anyone please help me.

    I have attahed my workbook
    Attached Files Attached Files
    Last edited by anilpatni1234; 12-20-2018 at 02:22 AM.
    Reply With QuoteRegister To Reply
  2. 12-20-2018, 01:21 AM #2
    kersplash
    kersplash is offline
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: formulae not able to automatically copy down in cells in a table

    I think this will have to do with the formulas in the entire column not being consistent. If I copy the formula from one cell into the entire column it works as expected.
    Reply With QuoteRegister To Reply
  3. 12-20-2018, 02:21 AM #3
    anilpatni1234
    anilpatni1234 is offline
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: formulae not able to automatically copy down in cells in a table

    hey kerpesh,
    thank you for your reply.

    What do you mean by formulaes not bieng consistent?
    Can you please me little

    HEre is my attached updated workbook.
    Please help me
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 12-20-2018, 02:31 AM #4
    FDibbins
    FDibbins is offline
    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,938

    Re: formulae not able to automatically copy down in cells in a table

    To start with, the formula in O is this...
    =MATCH(A3,#REF!,0)

    It has no range to test against.

    Because O shows an error, R cannot calc either
    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
    Reply With QuoteRegister To Reply
  5. 12-20-2018, 02:54 AM #5
    anilpatni1234
    anilpatni1234 is offline
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: formulae not able to automatically copy down in cells in a table

    Hey FDibbons,
    thank you for your reply.

    By mistake I had deleted 1 sheet.
    So here is my updated workbook,
    Please do have a look.
    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 12-20-2018, 11:57 PM #6
    anilpatni1234
    anilpatni1234 is offline
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: formulae not able to automatically copy down in cells in a table

    Was anyone able to glance through?
    Reply With QuoteRegister To Reply
  7. 12-20-2018, 11:59 PM #7
    kersplash
    kersplash is offline
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: formulae not able to automatically copy down in cells in a table

    One example of your problem, there is not a formula in every cell of Column O.

    O2 has nothing, O65 has nothing. The rest have a formula but what should the table do? It doesn't know because of inconsistency in the entire column.
    Reply With QuoteRegister To Reply
  8. 12-22-2018, 11:01 AM #8
    anilpatni1234
    anilpatni1234 is offline
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: formulae not able to automatically copy down in cells in a table

    Hey kerpesh.
    Sorry for the delayed response.
    I will work on it.

    Thank you so much for your support
    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. VBA code to replace formulae in cells and then re-enter same formulae again after run
    By excel_msa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2017, 06:56 AM
  2. Automatically copy data from one table into another table
    By rahul_ferns76 in forum Excel General
    Replies: 2
    Last Post: 08-03-2017, 09:25 AM
  3. Automatically copy formulae down as far as required
    By LeanAccountant in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2014, 05:02 AM
  4. [SOLVED] Can I copy and paste formulae out of multiple cells into, say, Notepad?
    By seanspotatobusiness in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2014, 10:44 AM
  5. how to automatically copy a few cells to a a table on another sheet?
    By Wolthers in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-05-2013, 07:15 PM
  6. Copy a table to multiple sheets and advance the formulae
    By benjaminjrp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2013, 06:15 PM
  7. [SOLVED] formulae to copy cells from 1 worksheet and paste into another?
    By MikeR-Oz in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 03-23-2006, 07:45 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