Macros to sort data with respect to the colum [Solved/Closed]

Question

Macros to sort data with respect to the colum [Solved/Closed]

Report

Test - Feb 5, 2010 at 12:39 AM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- Feb 5, 2010 at 04:50 AM

Hello,

I am facing a problem in sorting the data w.r.t to column header. I have 25 columns in which i need to sort the sata w.r.t to two of the columns. When i tried this with macros i found that the data is sorted along with column header as well and i am struck here without any clue.

Could any one of you help me out to overcome this issue.

Thanks in Advance.

Macros to sort data with respect to the colum
Macro to sort data with respect to the column - How-To - Excel
Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
Macro to copy data from another workbook - How-To - Excel
Excel - A macro to sort dates and remove duplicates - How-To - Excel
Excel - A macro to move data to another worksheet - How-To - Excel

1 reply

Ask a question

rizvisa1 · Accepted Answer · 2010-02-05T04:50:50-0500

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767
Feb 5, 2010 at 04:50 AM

you need to start from sort from row 2 and tell that there is a header

Selection.Sort _
Key1:=Range("A2"), Order1:=xlAscending, _
Header:=xlYes, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

Macros to sort data with respect to the colum [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!