Linking worksheets in Excel

[Tiffany]

I would like to link 2 worksheets in Excel (if possible, 2 worksheets
in different excel workbooks). I would like to link the sheets in
such a manner that when any cells in the initial sheet are updated,
the same cells in the 2nd sheet will also be updated. If a row is
added to the initial worksheet, a row should be added in the same
location in the 2nd spreadsheet. I would also like for the 2nd
spreadsheet to contain extra columns that are not linked to the 1st
sheet. In essense I am trying to link a requriements sheet to a
testing traceability matrix.

I would also like to "mirror" a sheet in Excel in the same workbook.
I would like to apply a filter to a large list of requirements and
save the filtered sheet in another worksheet. When the main sheet is
updated, I would like for the filtered sheet to also be updated. For
example, if I was gathering requirements for muliple divisions, I
would like to apply a filter by a specific division and store all the
requirements within that specific division from the main sheet in a
separate sheet. If I was to add a requirement to the main sheet, I
would like for the filered sheet to be updated with the new
requirement if it is in the specified division.


Please help if you can!

Thanks,
Tiffany

 

[Frank Kabel]

Hi
though this can be done within Excel (though not really with simple
formulas but with complicated array formulas and/or macros) This sounds
for me more like a database requirement with different views, foreign
key relationships and specific queries.

So I would try tu use a database and not Excel for this!