alphabetically

  1. S

    Sort a Combobox Alphabetically

    When my Userform loads a Combobox is populated using the following code: Private Sub comboboxFill() CmbFindProject.Clear totRows = Worksheets("Project Master").Range("A1").CurrentRegion.Rows.count For i = 2 To totRows CmbFindProject.AddItem Worksheets("Project Master").Cells(i, 1).value Next i...
  2. H

    Look in Column and Delete Certain Text

    Hi - I want to look in Column A and if the text "Grand Final" is found, I want to delete/clear that cell, and then sort alphabetically. Thanks!
  3. P

    Macro - Sort Column/Range Alphabetically

    This is, in fact, related to, and follows on from, a previous post - https://www.mrexcel.com/forum/excel-questions/1095651-macro-sort-column-range-alphabetically-taking-rows-them.html Summary I have recorded a Macro to sort a column (C) within Range("B24:AF218") to sort Column 'C'...
  4. W

    Sorting Specified workbooks

    How can I sort all worksheets in a work book alphabetically but specify one particular worksheet to be 1st and another last ?
  5. D

    Filter by certain column heading

    Hi, I have the below code - which sorts column B ascending alphabetically. As an example column B has heading called 'Country'; ActiveSheet.UsedRange.Sort Key1:=Range("B1"), Header:=xlYes However the above doesn't work in instances where 'Country' column doesn't appear in column B (It could...
  6. E

    Formula help -- sort alphabetically if amount equal

    Hello once again! I'm looking for help - I need to sort a list of items alphabetically if there is not a most popular one. I currently have a formula for the most popular products however I need it to show alphabetically if there isn't a most popular item. My current formula to show the most...
  7. D

    Sort to Last Row

    Hi - I have a headed table with dynamic number of rows and columns. I want to sort rows alphabetically ascending in column B. I have already used to establish the last row; Dim lastRow As Long lastRow=Cells(Rows.Count,"B").End(xlUp).Row I want sort column B alphabetically starting in row 2...
  8. J

    Sort Sheets Alphabetically

    Hello, so I have the following code which successfully sorts the sheets in a workbook alphabetically when run. I would like to make a couple of alterations to it. I would like it to: 1. Run automatically upon change to the number of tabs, e.g. when a sheet is added, and 2. Only to apply to...
  9. K

    Array Formula - sort results alphabetically

    Hi, I have an array formula, which returns a list of text codes - at the moment, these are not sorted alphabetically, however, I've now been asked to change this to return the codes in alphabetical order. Can anyone help...
  10. H

    VBA Sort A-Z

    Hi Guys, I require a worksheet change vba code; I have names in column A (A3:A72) All i need is a code that automatically sorts the data in A3:A72 in alphabetical order (A-Z) whenever a new entry is entered in any of cells A3:A72. I've looked online but couldn't find a sample code to do...
  11. J

    Inside Cell Sorting

    I have the following data in cell a1 A1=eeoe i would like to have a formula that will sort A1 data in A2 alphabetically A2 should = eeeo i would prefer a formula instead of Vba
  12. O

    Sorting excel records by "page"

    Our accounting office has this certification being issued for a student and it fits into a short bond paper. All those records are in a single sheet only. Now, we need to save them as PDF but they must be sorted alphabetically using the last name of the student. I am out of ideas on how to do...
  13. I

    Sorting a range alphabetically after input box adds new value

    I'm creating a worksheet that has one column and one header for the column. There is a button that prompts an input box and creates a new row in the column for the inputted value. I am trying to create a procedure that sorts the column alphabetically after the input box value has been added as a...
  14. N

    Insert Data Alphabetically Into Especific Range With Vba

    Hello everybody, I am a beginner in vba (and this forum) and I found the Thread to create a row and input data alphabetically here: I am using Excel 2013. http://www.mrexcel.com/forum/excel-questions/347531-insert-name-alphabetically-into-column-visual-basic-applications.html :confused: The...
  15. H

    Listing recurring values in a column alphabetically and automatically AND counting the occurrence of each value

    Is there a non-array formula and not using VBA script that would automatically pick recurring values in Column A, list them alphabetically (or alphanumerically) in Column B, and count how many times these recurring values appeared in Column A and list these counts in Column C? Thanks...
  16. H

    Listing recurring values in a column alphabetically and automatically AND counting the occurrence of each value

    Is there a non-array formula and not using VBA script that would automatically pick recurring values in Column A, list them alphabetically (or alphanumerically) in Column B, and count how many times these recurring values appeared in Column A and list these counts in Column C? Thanks...
  17. K

    Help sorting MCQ questions alphabetically

    I have a text file with MCQ's. after importing it every line got a separate cell The questions are not numbered and do not have any spaces between them. Some have ABCD. some have ABCD E as answers. As you see some questions have multiple lines (sometimes even 4 lines).. same holds for answers...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top