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!!!!!
>

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?