Sort multiple columns based in increasing order

[gauti14]

Hi all
i am quite new to programming and have the following issue:
i have 5 columns- column A with numbers ranging from 1 to 20 but not necessarily all numbers need to be present and in column C i have another bunch of numbers that can be anything in the following format --- 0001 to 0098.
For example:
Column A Column B Column C
1 0001
2 0002
4 0002
1 0002
4 0003
2 0005
1 0001

I want all similar values in column A grouped together such that their corresponding column b values are in ascending order(they can be repeated too)
Solution:
Column A Column B Column C
1 0001
1 0001
1 0002
2 0002
2 0005
4 0002
4 0003

Please help me out!!I really appreciate any help!

[gauti14]

Correction, the values in examples come under column c, column b is not needed..

[MarvinP]

hi gauti and welcome to the forum,

I think all you need to do is to first sort by column C and then by column A. See if that doesn't give you what you are looking for.

[gauti14]

thanks for your reply marvin, the issue here is i have 30 workbooks with 30 sheets in each of them..so i want to run a macro that would do this for all sheets

[Bip]

Probably the easiest way is to go to the 'Developer' tab in Excel and use the 'Record Macro' feature

[Logit]

Is your file set out like this (Example 1):

Column A.....Column B..... Column C
...1................0001
...2................0002
...4................0002
...1................0002
...4................0003
...2................0005
...1................0001


Or like this (Example 2):

Column A.....Column B..... Column C
...1...................................0001
...2...................................0002
...4...................................0002
...1...................................0002
...4...................................0003
...2...................................0005
...1...................................0001

[gauti14]

hi logit,its example 2..however i did this to achieve that...Sub FilterAndSort()
With Range("A1").CurrentRegion
.AutoFilter
.Sort Key1:=.Range("A1"), Order1:=xlAscending, Key2:=.Range("B1"), Order2:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End With
End Sub


Now i need to apply this to all the work sheets in the book (there are about 10...the names of the worksheets vary from eacg excel file.)can you help me out on how to do that

[Logit]

Here is a link with specific information for what your goal is. Hopefully this will (get 'er dun) for you or at least give you a start ....

http://stackoverflow.com/questions/1...le-excel-files

[Logit]

Here are some others:

http://stackoverflow.com/questions/1...o-in-that-file

http://www.mrexcel.com/forum/excel-q...orkbook-3.html

PROBABLY THE BEST RESOURCE:

http://www.rondebruin.nl/win/s9/win001.htm

[Logit]

I really don't like that the FORUM is acting up and won't let edits be made to a post. Having to post numerous ...

Do an internet search for : excel vba apply macro to other workbooks

Lots of links

[gauti14]

those links are helpful..thanks..but i need to do this across all the sheets in the same work book..not for multiple workbooks..sorry i should have made myself clear