custom sort

  1. B

    Custom sort pivot table columns of pivot table in google data studio

    Hi Team, Can someone help me with the custom sorting of pivot table in google data studio. I have column with data as Jan, Jan actuals, Feb, Feb Actuals etc and i want my columns to be in same order when i put it in to pivot table but it is not. Is there a way to custom sort them.
  2. M

    Custom List Sort Not Working

    I have a report I receive that I can't change the way the layout is exported, but I need the columns in a different order. I created a custom list with the column names in the order I need them. The list appears to have imported correctly, and when I type in the first value in the list, and then...
  3. starl

    VBE says there's code running but I can't find the code - then Excel crashes

    I've got a project (client confidential, cannot share) that, after the code runs, will eventually crash (eventually means less than 5 minutes or even 10 minutes later, it just sitting there doing nothing). I was in the VBE once before a crash, but I wasn't able to do anything (VBE was 'locked...
  4. A

    Macro only works on initial worksheet

    I'm working on a template that allows me to repeatedly copy the initial worksheet (e.g. sheet 1) and have multiple worksheets in a single file. I do repetitive data entry/manipulation and a system like this is key. I have a variety of macros I use for this workbook, some assigned to buttons and...
  5. T

    VBA Sort causes Excel to crash

    Sub AutoSort2() ' ' AutoSort Macro ' This will sort by the list of topics ' Dim dynlist As Variant dynlist = Application.Transpose(Sheet2.ListObjects("table2").ListColumns(2).DataBodyRange) ActiveTable = ActiveSheet.Range("b15").ListObject.Name...
  6. S

    custom sort button vba

    i need two buttons to sort my data because some days i need my data sorted in way 1 and sometimes in way 2 so i need 2 different buttons for it way 1: its a custom sort on column M and the custom list is ( 24 H, 48 H, 3 days, 4 days, 5 days, 1 week, 2 weeks, 1 Month, 2 Months, Monthly, Yearly)...
  7. tlc53

    VBA Code - Sort by Custom List Reference

    Hi there, I am trying to sort my data which is located under headings A52:K52 by the account number order, as stipulated in cells K21:K35. This is my attempt but it is possible I'm way off the mark. Can anyone see how I can get this working please? I don't want to refer to a particular sheet...
  8. V

    Custom sort order

    I have a list of products that need to be sorted in a very specific manner - the final sort order should be as described in the column titled "Overall Rank". The problem I have is that I need to first sort the products by the column titled "Date". Then, for a subset of the products (namely E...
  9. tlc53

    VBA Code - Custom Sort Data based on Range

    Hi, I have data headings on cells A50:K50. The length of the data underneath can not be determined, as it'll change all the time. I would like to sort the data underneath by account number, which is located in column K (header K50). The order I would like it sorted by is listed under K43:K48...
  10. L

    Sorting with vba, custom sort?

    Hi all, I am trying to sort a table in excel, I have the following code so far: <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Sub Sort_Table() Sheet6.ListObjects("Sort_table").Range.Sort...
  11. E

    Sort columns by occurance

    Hey guys, I am trying to sort a column by the occurance (or count) of a particular word. So for example if I had a column similar to this Cat Cat Cat Dog Dog Dog Dog It would sort the column based on their count (the items with the most occurance would be listed first and so forth). So it...
  12. R

    VBA Sort Col's Independent of One Another

    Hello, I'm trying to figure out how to sort columns independently of one another using VBA, and I have a good little piece of code that does this for me (see below). However, I've run into a couple of other things. Some columns may need a custom sort order, not just ascending. What does...
  13. A

    Custom Sort when worksheet changes

    I am looking for some advice. I have some code that will sort the columns exactly as I need but currently sorts in ascending order. I am looking to modify the code to sort by a custom order. I recorded a macro to try and work out the code but when I place the recorded bit of code in my...
  14. M

    Code runs in Module not in sheet code

    Hi, I have a custom sort code, which runs perfectly when I am calling it from a module, but when I copy it inside the my codes in the sheet, and address it, it returns error. Can somebody help and explain? here is my code: Sub custom_sort() Application.calculation = xlManual...
  15. R

    Sort array w/ custom alphabet [a-z + æøå]

    I wish to sort an array of strings alphabetically including the nordic characters Æ, Ø, Å. Nordic alphabet = "abcdefghijklmnopqrstuvwxyzæøå" Most sorting algorithms I've come across (bubble, quick, merge) sorts by checking if "bb" > "ba". which works well for "" However, "æ" >...
  16. L

    Custom Horizontal Sort (VBA)

    Hi there. I've put together a small bit of code that applies a custom sort order horizontally, which is defined by the contents of a range of cells on another tab. Here's my code: Sub Custom_Sort() With Sheets("Data") Application.AddCustomList ListArray:=Sheets("Sort...
  17. M

    VBA custom sort by category total

    Tried my best to figure out the best way to do this and came up short. My data looks something like this: <tbody> Category 1 Category 2 Account Desc FY13 FY14 FY15 Revenue Product 1 Sales 100 110 115 Revenue Product 3 Sales 100 150 300 Cost of Revenue Product 1 COGS 20 30 30 Cost of...
  18. andrewb90

    VBA sorting error

    Hello All, I used the macro recorder to sort a range automatically and it seemed to work when I recorded it, but now I get an error, I was hoping someone could help me figure out why Sub range() range("B5:V341").Select ActiveWorkbook.Worksheets("Shed").Sort.SortFields.Clear...
  19. J

    Custom sort using named ranges

    Hello - I'm having trouble developing a custom sort code that uses values in a named range for the sort options, and was hoping that someone could point out what I overlooked - I just started using sort codes yesterday, and the Range.Sort syntax provided by Microsoft is less than helpful.. I'm...
  20. W

    Custom Sort List For Pivot Table

    I am trying to use VBA to create a custom sort list for a pivot table based on the order of items on wkst SortLst. My Pivot table is is Sheet2(Company Wide). I am getting subscript out of range error. Sub PivotTableSortUsingCustomLists3() Dim rng As Range Set rng =...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back