+ Reply to Thread
Results 1 to 5 of 5

Insert rows in linked table that are added to secondary table

  1. #1
    Ida LaValley
    Guest

    Insert rows in linked table that are added to secondary table

    I am trying to work with linked tables so that I only have to type data once
    and then other sheets automatically update. If I change existing data, both
    tables update. The problem comes in when I try to add data. For example, I
    need to add row 6 to a table with 9 items existing. When I add row 6 to the
    source table, the secondary table updates the already existing field as far
    as where they are, but will not add in row 6. HELP!!!!!

  2. #2
    RagDyer
    Guest

    Re: Insert rows in linked table that are added to secondary table

    Say your data was on Sheet1, from A1 to A9.

    Enter this formula in the other sheet, and copy down *more* rows (say to
    A15) then you presently have data in, to prepare beforehand for the addition
    of extra rows.

    =INDIRECT("'Sheet1'!A"&ROWS($1:1))


    --
    HTH,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------

    "Ida LaValley" <IdaLaValley@discussions.microsoft.com> wrote in message
    news:EE12289A-9809-47D2-91A7-66169E772FB7@microsoft.com...
    >I am trying to work with linked tables so that I only have to type data
    >once
    > and then other sheets automatically update. If I change existing data,
    > both
    > tables update. The problem comes in when I try to add data. For example,
    > I
    > need to add row 6 to a table with 9 items existing. When I add row 6 to
    > the
    > source table, the secondary table updates the already existing field as
    > far
    > as where they are, but will not add in row 6. HELP!!!!!



  3. #3
    RagDyer
    Guest

    Re: Insert rows in linked table that are added to secondary table

    Actually, a non-volatile function might be better:

    =INDEX(Sheet1!A:A,ROWS($1:1))

    And copy down.
    --
    Regards,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------
    "RagDyer" <RagDyer@cutoutmsn.com> wrote in message
    news:uWOAAVWxGHA.2448@TK2MSFTNGP05.phx.gbl...
    > Say your data was on Sheet1, from A1 to A9.
    >
    > Enter this formula in the other sheet, and copy down *more* rows (say to
    > A15) then you presently have data in, to prepare beforehand for the
    > addition of extra rows.
    >
    > =INDIRECT("'Sheet1'!A"&ROWS($1:1))
    >
    >
    > --
    > HTH,
    >
    > RD
    >
    > ---------------------------------------------------------------------------
    > Please keep all correspondence within the NewsGroup, so all may benefit !
    > ---------------------------------------------------------------------------
    >
    > "Ida LaValley" <IdaLaValley@discussions.microsoft.com> wrote in message
    > news:EE12289A-9809-47D2-91A7-66169E772FB7@microsoft.com...
    >>I am trying to work with linked tables so that I only have to type data
    >>once
    >> and then other sheets automatically update. If I change existing data,
    >> both
    >> tables update. The problem comes in when I try to add data. For
    >> example, I
    >> need to add row 6 to a table with 9 items existing. When I add row 6 to
    >> the
    >> source table, the secondary table updates the already existing field as
    >> far
    >> as where they are, but will not add in row 6. HELP!!!!!

    >



  4. #4
    Registered User
    Join Date
    11-16-2020
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Insert rows in linked table that are added to secondary table

    This thread has helped me with my initial problem of the 'target' table not updating when adding new rows to the 'source' table.
    But in the 'target' table I have data in colums next to the source data which is entered manually and is related to the data from the specific row of the 'source' table.
    When a new row is entered in the 'source' table the colums with the INDEX formula update to add the new row but the other colums do not update and the data is mismatched.
    Is it possible to have the INDEX function add 'blank' fields to the 'target' table for the rest of the row?

  5. #5
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,455

    Re: Insert rows in linked table that are added to secondary table

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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