do a sort, then apply and autofilter. If you are just sorting to get those
rows adjacent, then you don't need the sort

http://www.rondebruin.nl/copy5.htm

--
Regards,
Tom Ogilvy




"Dheeraj Khanna" wrote:

Hi, I am looking to know any macro or any farmula where it first sort the
data on one criteria and then copy the data from other Rows and columns of
the related Criteria to another sheet.

Kindly help me on the above