Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |