I feel I've searched thoroughly and wasn't able to find the right answer. I've attached a daily report example that needs the "Product" field to be sorted in a particular order. The order should be JEX, Q3791J, YOO5, KLX9, GHT (all similar products need to be grouped together).
Since the report is run daily the number of rows changes daily: one day can have 50 entries and the next 10. Is there a way to dictate the sort order and insert a blank row between each product grouping?
Once the Products have been separated into their groups, how would I sort each grouping by the "Term" column?
Is it possible to make excel sort ascending or descending but from mid way through alphabet and then loop through the alphabet again. for example. If Cell A1 had "A" in, it would sort as normal.
Cell A1 = A Cell A2 = B Cell A3 = C Cell A4 = D Cell A5 = E
If Cell A1 had "C" in, it would sort from "C" through the alphabet and then loop to the start of the alphabet as shown below.
Cell A1 = C Cell A2 = D Cell A3 = E Cell A4 = A Cell A5 = B
I am trying to create custom sort list. It works below when I define range as A1:A79.
Sub SortWS2() Dim SortOrder As Variant Dim sheetsorder As Range Dim Ndx As Long Application. ScreenUpdating = False With Worksheets("Sort Order").Range("A1:A79") For Ndx = .Cells.Count To 1 Step -1 Worksheets(.Cells(Ndx).Value).Move before:=Worksheets(1) Next Ndx End With Application.ScreenUpdating = True End Sub
I have created a dynamic range called sheetsorder. If I revise my code it does not work.
I would like to sort my column A by "Urgent, High, Medium and Low". However, when I click on sort, it obviously sorts alphbetically. Need to code to sort all colums A:K.
Is it possible to do a custom sort on a column so that I can change the order the way the months are sorted. The order I'm looking for is:
October November December January February March April May June July August September
Also the format for the cells in that column is 01-Jan, I don't want to see the year because I enter and sort the date as if the year doesn't matter so it automatically registers as 2014, if that makes sense. Basically I want that order of the months regardless of the year.
As of right now these are the steps i do to sort...i click custom sort choose My data has headers and then i select from the drop down list the word FRNAME.
is there any way i can setup a macro to do this for me? i tried recording the macro but it just is recording me choosing the column FRNAME is in. This does not work for me since FRNAME end up being in different columns all the time but will always be in row 1.
I need a code to sort worksheets in a huge workbook. Is this technically possible!?
The information containing the worksheet order is available in worksheet "Aux", column A contains the rank (1,2,3,...etc.), whereas column B contains the corresponding worksheet names.
I am trying to write a formula whether it be in VBA or a Macro that will do the following.
In cell A7 and A10 there are validation boxes that drop down with a list of items that can be selected.
We want the user to be able to add multiple items under each month but keep the list to only what is needed. Therefor the function I am trying to get is once cell A7 has a selction or isnot blank or is greater than 0 we want to add a line directly below it with all the same functionality as line 7. Everything else will shift down and maintain the same functionality.
I have a attached a sample workbook... Can this be done
I Have A List That Is Generated From Another Program Dump Info Into Excell. This List Has Names In One Colun And Corresponding Values In The Next Column. My Goal: Get The Name And Values To Be Listed In A Specific Order To Be Copied To Another Workbook. Issue: All The Names Do Not Always Get Sent From Original Program. Example:
Person1 Always Needs To Be In Row2 Person 2 Always Needs To Be In Row3 Etc However Person1 May Not Be On The List Today. In Which Case I Need Row2 Blank
I have a list of data with headings number,name, surname,group. Data needs to be kept in the rows as they are now but I would like to sort the order by group. The group order needs to be:
sm, u17m, u15b, u13b, u11b, sw, u17w, u15g, u13g, u11g. I would like to do this using vba and have a blank row between each group.
I'm sure this has been asked many times before, but I can't seem to find an answer that works for my data. I have some data that is sorted by an ordered list (like a table of contents from an overly detailed book):
1.0 1.1 1.2 1.2.1 1.3 ... 1.11 ...
This list can be arbitrarily deep (although probably not more than ##.##.##.##), and because I'm using periods to separate the nested levels (can be changed), I've formatted it as text. This means when I sort the data using this column I get 1.11 before 1.2 (text sort order).
After lots of failed formula attempts I've resorted to using an additional column with hand-entered values to sort by so it will sort correctly:
1.00.00 1.01.00 1.02.00 1.02.01 etc
but I'm hoping someone knows a more elegant way to do this, or at least to generate this column without typing so many zeroes!
I have a client with a list of books, and they are trying to sort a column in a sheet that has LC classification codes. When just doing a normal A-Z sort, it looks like this:
What is weird about it is that I would think that the numbers after the RJ would be in numeric order but it seems to be treating them as codes. So, instead of RJ 41, then RJ 45, it goes on with a series of things that start with RJ 41. Is it normal for this to happen, or is there a way to change it so that it goes 41, 45, 47, 48, then 416, 420, etc.
I would like to custom sort a table by ID, the first ID to be shown on top would be the ID the user enters in an inputbox. Below is the code I used but I don’t know why its not working:
Sub CustSort() Dim MyCount As Integer MyCount = Application.CustomListCount + 1 MyValue = InputBox("Enter ID") Application.AddCustomList Array(MyValue) ActiveSheet.UsedRange.Sort _ Key1:= Range("A1"), _ Order1:=xlAscending, _ Header:=xlYes, _ OrderCustom:=MyCount, _ MatchCase:=False, _ Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Application.DeleteCustomList MyCount End Sub
find attached an example, try entering 300000 in the inputbox the custom sort doesn’t work
I have imported data and numbers from a website and would like to sort the data in numerical order. Excel wants to sort the data 1,10,2,20... in that order. I know from past experience with an older version there was a way to convert the numbers so they can be sorted in the way that I want.
I have 2 listbox (List1 and List2). List2 get populated when the user select a value in List1 and based on the value selected in List1. My issues are:
1- Values in list2 are not sorted in ascending order especially when the list2 grows over 32. 2- When the user selects "None" in List1, it should clear List2 (onclick)
I worked on this code for a while with no luck trying to get it to work. Is that doable?
VB:
Option Explicit Dim ufEventsDisabled As Boolean Function SelectedString() As String Const Delimiter As String = "," Dim i As Long
Don't know if macro is better, but I would like to try it with function
I have 2 sheets.
Sheet 1 Column A: Name Column B: Points
Exemple: Name Points Mary 40 Johnny 20 Erick 60 Ralph 30
I want Sheet 2 to get data from Sheet 1 and sort by descending order automatically.
Then it should be
Sheet 2
Name Points Erick 60 Mary 40 Ralph 30 Johnny 20
I don't want to do it manually every time I change some value; I want it to do automatically; so if I change, for example, Erick's points from 60 to 10 in Sheet 1, Erick should appear on the last place in Sheet 2, with his new value (10)
I have a spreadsheet for work that consists of various columns of data. One important sorting column would be Job #. Inside this coulumn are data like 134-Q and 2355-P and 755-P for example. The sort now is like posted. I would like to be able to sort by both alphabetical and numerical order. ie, 755-P, 2355-P, then 134-Q.
Im totally new to excel and have some data i need to sort. how to sort numbers into ascending order across a row. ie, I have 34 2 45 79 102 63 etc, and I need them to start low and order to high. i have over 1200 rows, so it would be good to do the whole sheet at the same time.
At this time I sort by HOURS then Seniority so the sort would look like this:........
Here is the problem, RN HILLER and JA DOE have the same hours and seniority. It is our policy that when 2 or more names and seniority match, they must be sorted by reverse order first letter of last name.
So this would be correct. H in Hiller comes before D in doe when reverse sorting.....
I have the below code that sorts a list of Doors that I have in row C17 downwards. Door 54, Door 7, Door 109 etc. The list is feeding a drop down box, people find the door they were looking for, in the said drop down box.
Code:
Sub ListSorter() Dim LastRow As Long LastRow = Range("C" & Rows.Count).End(xlUp).row
[Code]....
I wondered if there was some code I could add to the end of this, that would the sort worksheets, which are all named after each cell in the list, in the same order.
In the below code, when I want to sort on Column "A" it is not working. Anything stand out that would prevent my code from working?
Sub Delete_Duplicates()Dim LastRow As LongWith Sheets("SAP Raw Extract")    LastRow = .Cells(Rows.Count, "A").End(xlUp).Row    'Create ID Column        .Columns("A:A").Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove        .Range("A1") = "ID"        .Range("A2").FormulaR1C1 = "=RC[5]&RC[6]&RC[32]"       Â
I'm using a table with columns from A to F and an unlimited number of rows. Note that there is a title at the top of each column. -I'd like my datas in column F to be automatically sorted in descending order from top to bottom when I hit the enter key or when the number is entered in last column (column F). -the the entire row of data needs to be sorted according to the sorting criteria of column F ( datas entered need to stay on the same row) -the macro should validate that the number value entered in column F is the same as the number value entered in column A. (to make sure that there was no typing mistake) -Result in column D must be the difference between the corresponding value in column B and C (B-C=D) *The next couple of constraints are not absolutely required, i'd like to have them only if it's possible to add constraints with filling color: -Whenever there is no value entered in column C on a specific row I'd like the entire row to be colored in yellow (fill color) -IF a number is entered in column C, and that the result of B-C in column D is not equal to zero, I'd like this specific row to be filled in Red. -when all the values are entered in a row from column A to F and that the result of B minus C is equal to Zero in column D, i'd like this specific row to be filled in a green color. ***in other words, the datas in each rows from column A to F will be entered on 2 occasions; on the first time, only the datas in column A,B and F will be entered (so basically after entering this set of values the row should be filled in yellow. the second time, the remaining values will be added to the rows, so at this time A,B,C,D,E and F will all be entered. when this is done there will be two options 1-the value in column D is equal to Zero then the entire row should be filled in green or 2-the value in column D is'nt equal to zero, then this specific row should be filled in red.
Keep in mind that the datas of a row should be automatically sorted only when the value in column F is entered or when the enter key is hitted to add a new row.
I am trying to sort a combo box by ascending order...this combo box displays 2 columns of data which are populated from a spreadsheet. I would like to sort by the first column in the combo box which is numeric, but I do not want to sort the actual data on the spreadsheet.
