Sorting and Subtoaling
 

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

Sorting and Subtoaling
 

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