Sort a coloum on one worksheet according to another coloumn on ano

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 1 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 one coloumn according to another coloumn on another worksheet 0
How do I copy cells from one worksheet to another based on values 2
How to compare a row data from one worksheet to another worksheet 5
Returning a Value from Another Worksheet 2
Sorting a list according to other list 13
matching 2 worksheets to find differences 2
Reference to another worksheet cell in a sumproduct formula 1
#N/A via Vlookup to produce name from other worksheet 2

Top