sorting

Hi all, I would like to avoid use any excel native functions and i would like to use vba code so that to sort the range of rows "A9" : "M" and rows down, sorting them by column "B" A:Z (alphabetical) Thank you all in advance

Hi All, I'm trying to run the Macro below but it crashes every time it get to the highlighted .Apply line. I have no idea why since it did not crash on the first .Apply line. Can someone please point me to the right direction? Thanks Dim arng As Range Dim brng As Range Dim crng As Range...

Evening, I have a report that is produced from a front end system where names are entered with a comma separating them, some have 1 name, some 2 names some 3 or 4 for example: Jo Blogs, John Smith Shaun Green Betty Jones, Sharon Blue, Harry Grey Is there an easy way to separate the names...

Hey, I have grouped amounts and it equates to the subtotal. I would like to sort all of the subtotals will my groupings follow?

I have a spreadsheet with a lot of interconnected cells. All of the formulas on each row reference cells only on that row. When sorting based on the values in one column some of the other columns shifted along but others didn't. What could I do to make all the cells in the row shift along with...

I made a template. after Putting in all the data Itried sorting one of the columns smallest to largest. I see in the background that it does the sorting but then it quickly scrambles all the data. WHY!:mad:

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

Hello, Can someone please help to suggest how to do dynamic multiple sorting with criteria in VBA? I have a data table with header title : LOCATION, ITEM#, CATEGORY in different columns that i would like to sort the table in the following column sequence. 1st sort : LOCATION 2nd sort...

The problem here is I am poor at creating sorting macros, and use the recorder, and tried to implement a variable for the bottom row. This is an easy fix, right? I am getting error for this, "doesn't support this property or method". The first error is in Bold below. B_Row is defined just...

Hi Fluff/Everyone, HNY! :smile: https://1drv.ms/x/s!Aszg_mMOoSFEgRyt-qUa9uRsOkZG Could you have a look at my spreadsheet and tell me if there is a way of keeping the formulas in the same order as the rest of the data after sorting it using the buttons? I had a play with changing the...

Hi Team, I have problem in sorting pivot values and it will never get sort. I have copy and paste special then I perform the sort. Is there any option do I need to enable to sort Pivot data? I am using 2016 MS Excel. Please suggest me. Thank you

Help sorting range using vba. I'm trying to sort two columns with formulas which has blanks as the result of the formulas. I'm trying to sort so that the blanks in the range are at the bottom and the sort is on cost highest to lowest. See example below Any help is appreciated...

I have two tables of data that I am using to create Pivot Tables and Pivot Charts. Then I'm creating slicers which slice multiple charts from the two different sources (via technique from this video: https://www.youtube.com/watch?v=AibLsRM-QbI ) One of the slicers needs to be Day of the Week...

Good day. I am running Excel out of Office 365 on Windows 10. I was working in the Developer function editing a macro. Normally, on the left side of the screen is a list off all the available Modules. I tried to hide some modules with a number higher than 9 because the list was sorting 1...

Hello, Trying to sort my data as follows: Sorting is based on the Color, for this example White >75% first, when all White >75% are gone then sort for all Blue >75%, When all blue are gone sort for all Red >75%. If no Color is >75% then sort using the color that has the greater %. In cell B211 I...

Hello, I have a data sheet with columns A-R and about 3200 rows. Column A is a work order number and Column K represent the amount of days it took to complete that work order. There are situations in which there are duplicate work order numbers (2 jobs at once) and that results in two...

Hi, I have SQL connection that load data into Excel Table. I have set sorting criteria in that table (Excel Table, not SQL query) so my question is: Will this sorting still be valid after data load refreshing??

I have used Excel for over 30 years and have never encountered this problem. When I sort, it tells me that I have a circulation issue (which I do not). It also says there could be a problem with WK1 (whatever the heck that is) Trying to read about WK1 was very limited and even mentioned...

In Excel, there is a nifty sort feature you can use to sort by several columns of information. For example, if your data looks like this: <colgroup><col><col></colgroup><tbody> Name Type apple tree ginger root pear tree grape vine apricot tree carrot root banana tree muscadine...

Hi, Office 10, Excel version 14 I'm using Data/Filters, with headings in rows 1 and 2. When I sort, row 2 naturally sorts as well, as only row 1 has been recognised as a heading by filtering. I can easily freeze the top row from scrolling, but I'd also like to freeze the 2nd row, and exclude...