Compare and sort random data between different sheets [Closed]

Registration date
Wednesday May 7, 2014
Last seen
May 7, 2014
 Blocked Profile -

In one sheet I have 200 Names and their phone numbers ( in 2 columns) .

In the 2nd sheet, I have 100 names ( those belong to original 200 names in 1st sheet, but are in a RANDOM order )..

In the 2nd sheet, i need to look up for phone number from 1st sheet for the corresponding name and place it on the column next to the name on 2nd sheet

how can I do that.. Thank you..

1 reply

Have you tried the built in function of filter? You can filter the columns by data drop down. See if that helps.

You could possibly sort, also. Both are built in ready to use actions, no programming required. What you are asking is a Macro, and not easy to deploy if you are not familiar with them!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!