custom sort

Hi, Is there a way to make custom sort work correctly on larger files? I created a custom list but both in VBA and in regular excel it does not work correctly on larger files, while it does work perfectly fine on smaller files. Is this a known issue and is there a way to resolve this? Current...

I have an excel file file about a thousand entries that we number like following (please copy/past this in new sheet) Index Item Number 1 F1 2 F2 3 F3 4 F3.1 5 F3.2 6 F3.3 7 F3.4 8 F3.5 9 F3.6 10 F3.7 11 F3.8 12 F3.9 13 F3.10 14 F3.11 15 F4 16 F5 17 F5.1 18...

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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 "01...89abc..xyz" However, "æ" >...

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

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

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