Jump to content

Need help on a question bothering a lot.

Shashikala Raju
in Computer Science

Featured Replies

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 by Shashikala Raju

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.

Archived

This topic is now archived and is closed to further replies.

Go to topic listing

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.