If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking worksheets in Excel
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! -- Regards Frank Kabel Frankfurt, Germany "Tiffany" schrieb im Newsbeitrag om... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking PowerPoint Chart to Excel Data | Kevin T | Powerpoint | 1 | June 15th, 2004 07:44 PM |
Linking data from Excel to Word | Kolja | General Discussion | 1 | June 9th, 2004 08:17 PM |
Linking Excel data through Access to use a Form as an Interface | Laura | Links and Linking | 0 | March 23rd, 2004 03:59 PM |
auto format 5 worksheets out of 6 when opening excel spreadsheet. | mike | Worksheet Functions | 1 | December 26th, 2003 08:37 PM |
Automatic linking of cell data between worksheets | CherylB | Worksheet Functions | 0 | December 10th, 2003 05:58 PM |