Structure Reference weird

    Hello all,


    I have a simple excel that has two sheets. One FORM and second RATE

    Both have Tables.

    My need is, when the table in sheet FORM fills then automatically fill and the table at sheet RATE

    I am trying to make it happen but #Value keeps coming. I understand that my first table starts from Row 17 and the second from row 1

    What can I do?

    The formula am using is =Invoice[@[PCS]:[PCS]]

    I hagve attached the excel if it can help


    Thank you!

    test-excel.xlsm

    Hello,


    Not totally sure to understand your question ...


    Is your question about Linking Tables ....?


    How to Link Tables in Excel (3 Easy Methods) - ExcelDemy
    This article describes 3 quick ways to link tables in Excel. Download the workbook. Practice and use these methods to solve your problem.
    www.exceldemy.com


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Like 1

    Thank you for your answer

    Something like that, but I need the values to be inserted in another table (RATE), so I need to insert specific values [PCS].

    If you see the example if something change at the first table the values inserted to the second one and use them to do calculations


    My English are not that good... I hope you understand. The fact is that I can do that on Windows but on MAC is not working

    Sorry but I do not know how to use Excel on a Mac ... :(


    Should you need a macro to fix your problem, thanks for attaching a test file with five or six records in order to better visualize your actual objective and your expected results ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Edited once, last by Carim ().

    Understood and respect.



    Thank you !



    Cross Post :thumbdown:


    Table Reference
    Hello all, I have a question. I need to reference to another sheet the value of a cell that is in a table. I need this to be inserted at an other table at the…
    www.mrexcel.com

    Edited 3 times, last by Carim ().

  • rory

    Added the Label Cross Post

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login