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: 4475
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: January 6, 2016

- 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
Excel macro that inserts data with a button - How-To - Excel
Macro to pull data from another worksheet based on criteria - How-To - Excel
Make a macro run when data entered in a cell - How-To - Excel
Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel

1 reply

Ask a question

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

Answer 1 / 1

rizvisa1

Posts: 4475
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: January 6, 2016

756
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

Grammarly Keyboard

Amazon Fire TV

OnLog

Tricount

Citymapper

YAZIO

Candy Crush for PC

CallApp

Garena Free Fire: Spooky Night

30 Day Fitness Challenge-Workout at Home

Pokémon Masters