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