I was trying to copy the specific records in a list from one site and want to create a new list in another site with selected records.
Hi Sudhakar,
If you are having a lookup field, for it to work fine, you need to maintain the list IDs intact in source and destination. Does your site 2 has the master list (where your list looks up to) with the same list ID?