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...

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!

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'...

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

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...