Sorting complete worksheet

[hsandeep]

In Sheet 2, i am copying data of Sheet 1 using vlookup.
Now I want to sort Sheet 2 on column B which contains alphabetical names to be done in A to Z order.

How to sort the complete Sheet 2?

I am ready to apply another logic if it works.

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?641044-Sorting-new-ws

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).