This is hard to explain, but I'll do my best.
- I have a SP list where I update the data from an excel file and copy&paste it into the datasheet view of my SP list.
- I have a SP custom view of this list that only shows a handful of the columns available.
- I then have added 2 columns of additional data to each entry in this SP list.
Question: To maintain my data I regularly have to copy&paste the excel data as in step 1. If rows are added/removed, will the data in the columns from step 3 still retain their association to the correct data? And if not is there a way to do this?