Can anyone help me figure out how to refresh data that represents part of a worksheet and still maintain the relationships with the other columns that exist in the same spreadsheet? Here’s the details:
I have an excel sheet with the following 9 columns:
CR Number | Priority | Synopsis | Target Release Iteration | Workflow Status | Type | Responsibility | LOE | %complete | devleft
– The first 6 columns were imported from a text file (dump from borland star team)
– The first column, CR Number, is a unique ID for each row
– The remaining 3 columns are extended data that is not part of the original text file but that I want to maintain for each row.
Question: I am looking for a way to refresh the data in the worksheet (via the text files) without losing the existing relationships between the records (CR numbers) and the additional data I am maintaining in the 3 other columns.
I appreciate any help you can provide.
-Doug
