Previous Topic Next Topic

Compare and sort random data between different sheets

Closed
jhanviathaker Posts 1 Registration date Wednesday May 7, 2014 Status Member Last seen May 7, 2014 - May 7, 2014 at 05:07 PM
 Blocked Profile - May 7, 2014 at 05:16 PM
Hello,

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..

Related:

1 response

Answer 1 / 1
Blocked Profile
May 7, 2014 at 05:16 PM
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!
0

Similar discussions

Why does our account keep randomly following additional users every few weeks?
Coach -
ElenaKM -

1 response
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
AMD data change update new data to DMI
Luis -
dwebb -

1 response
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses