Excel as relational database - data rows
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?
|