Question Locked

how to refresh part of a worksheet

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

This discussion is closed to new replies.