Need help on a question bothering a lot.

[Shashikala Raju]

Guys,

 

can anyone tell me if there is a technique to capture only the selected information from a 'copy' action and paste it on a sheet that has labels which have the same name as the copy area..

 

If I'm not clear, I'd cite an example.

 

sheet1 has :

Name : Sam

College : GSC Place :

Bangalore Batch : 2010-2012

 

Sheet 2 has,

Name :

College :

 

Now if I copy all from sheet 1 and paste it in sheet 2 it should capture only those fields that have the same name, others should be simply ignored.

Edited December 17, 2012 by Shashikala Raju

[iNow]

I would use vLookup to determine which values are already contained in the other sheet. Then, just filter for the ones not already in your second sheet, copy, paste, done.