Alphanumeric Sorting for multiple columns

  • Can anyone help me with an alphanumeric sorting code for multiple columns sorting (column by column sorting) advance.

    Also let me know If the following code can be used for multiple columns:

  • Re: Alphanumeric Sorting for multiple columns

    Same rules here as on Excelforum - Please wait a sensible period before bumping a thread.

    But a rule more rigorously enforced is:

    Rule #4 - Do not cross-post without supplying a link to the duplicate question on the other forum.

    You also posted this topic on ExcelForum. While you are free to post where ever, every board like this has a similar rule - you must include links to all you posts on other boards.

    Have a read of this to understand the reasons for this rule.

    You should update this thread with the URL of any other threads dealing with this particular issue, and ensure future posts by you comply fully with the rules.

  • Re: Alphanumeric Sorting for multiple columns

    Dear All,

    I have attached a sample of requirements.

    My data is in the format "# = XXXX" where # can be any number between 1 to 500 and XXXX can any number alphabets. I have to sort the data in descending order based on the digits. I am not concerned about the order of the alphabets. Also, the number of columns in the worksheet is very large (more than 1000). So I cant not work on individual columns. I think only a macro can help me here. I hardly have any experience in coding. The code I shared in my earlier email extract the numbers from a cell and sorts the first column based on the numbers. But it works for a single column only. I am not sure how to modify the code for it to work for 1000 of columns at a go. Thanks in advance.

  • Re: Alphanumeric Sorting for multiple columns

    try this

    sub test()
    Do While ActiveCell.Address <> Range("IV1").End(xlToLeft).Offset(0, 1).Address
    ''''your code here
    ActiveCell.Offset(0, 1).Select
    End Sub

    hope this helps

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!