What I hear you say is that you're editing or adding new data to a linked table. The table gets refreshed and the data that once was associated to a certain person or item has moved to a new row?
Are you adding this new data back to the linked table? I would think you need to work with a static version, and this is how I'm imagining this going.
* The table gets refreshed before adding new data.
* The table gets copied to a new sheet as static values
* New data is added or changed
* Data is merged with original linked table and static table is wiped clean
* Table is refreshed and the process starts again
If this process is adopted, you'll need some code to make the static table and also to merge the data back to the link.
Jeff
