software

I'm trying to use Excel 2003 as a relational database (don't know if it's a
good idea, but I have to try).

The first sheet 1 contains my basic database content.
On sheet 2 there's data, which contains direct reference to sheet 1.

The way I would want it to work, is that when I update sheet 1 by adding a
row of data in the middle of a table, sheet

2 would follow its lead and keep the row order as in sheet 1 (that is, add
an empty row to relative position). So, in fact, I would like the 'data rows'
in each sheet to match without manual linking and adding rows.

I wonder, if there is a way to make this work?

Not clear what you are trying to achieve here? If the data on Sheet 2 is
related to that on sheet 1, shouldn't it be on Sheet 1?

quot;AndyLuciaquot; wrote:

gt; I'm trying to use Excel 2003 as a relational database (don't know if it's a
gt; good idea, but I have to try).
gt;
gt; The first sheet 1 contains my basic database content.
gt; On sheet 2 there's data, which contains direct reference to sheet 1.
gt;
gt; The way I would want it to work, is that when I update sheet 1 by adding a
gt; row of data in the middle of a table, sheet
gt;
gt; 2 would follow its lead and keep the row order as in sheet 1 (that is, add
gt; an empty row to relative position). So, in fact, I would like the 'data rows'
gt; in each sheet to match without manual linking and adding rows.
gt;
gt; I wonder, if there is a way to make this work?