I need to know how to copy data of specify columns from one list to another using 1 common column in sharepoint 2007. For e.g. In one list i have employeenumber,contact number and mail address. And I want to copy contact number and mail address to another list based on employeenumber. Please let me know how to do that as i am new in sharepoint.

1

There are 1 best solutions below

0
On

We can do this in many ways, Let me tell same scenario in different form.

Case 1: you have list in same site web

  • get web object
  • make 2 spList objects
  • using 2 foreach traverse through list collection
  • assign values.

Case 2: you have list in different site web

  • get web object
  • get source list object
  • get destination web object
  • get destination list object
  • using 2 foreach traverse through list collection
  • assign values.