Skip to main content
SharePoint

Return to Question

improved formatting
Source Link
MHeld
MHeld
  • 5.1k
  • 5
  • 27
  • 40

This is hard to explain, but I'll do my best.

  1. 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.
  2. I have a SP custom view of this list that only shows a handful of the columns available.
  3. 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?

This is hard to explain, but I'll do my best.

  1. 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.
  2. I have a SP custom view of this list that only shows a handful of the columns available.
  3. 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?

This is hard to explain, but I'll do my best.

  1. 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.
  2. I have a SP custom view of this list that only shows a handful of the columns available.
  3. 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?

Source Link
lmnop
lmnop
  • 1

List Datasheet upload & added column

This is hard to explain, but I'll do my best.

  1. 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.
  2. I have a SP custom view of this list that only shows a handful of the columns available.
  3. 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?