Sort one coloumn according to another coloumn on another worksheet

S

Sunir M S

Hi guys.

i am a newbie. i went through all the posts but couldnt inderstand.

I want to sort coloumn A on worksheet 2 according to coloumn A on worksheet2.

e.g

Coloumn A ( Worksheet1) B | Column A (Worksheet 2
harry H david
david D craig
craig C harry
smith S smith

The contents of coloumn A will not be the same order every day. Could
someone help me sort col A of worksheet 1 after matching it with the strings
in colomn A worksheet2.

The only criteria to sort would be mathcing the strings. i.e names

the out put should look like:

( Worksheet1) (Worksheet 2
Coloumn A | Coloumn B || Column A
david D david
craig C craig
harry H harry

smith S smith

Thanks in advance
Sunir
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort a coloum on one worksheet according to another coloumn on ano 0
How do I copy cells from one worksheet to another based on values 2
copy an entry to the first free cell in a coloumn (vba?) 0
Returning a Value from Another Worksheet 2
How to compare a row data from one worksheet to another worksheet 5
NEED MACRO TO GET BALANCE 2
count if unique entries 3
Formula for looking up and copying from another worksheet? 1

Top