sort table

  1. S

    Using VBA to Sort a Table with a Custom List

    Hi, Thanks for looking at this... I have the code below that takes a custom sorted list from a Listbox in a Userform puts the items in to an Array and then creates a custom sort to be applied to a table called 'RotaOutbound'. The code all works fine when I tested it on a list in a column but...
  2. M

    Sort Table Macro with Changing Row Amount

    Hey Guys, I'm looking at creating a Macro or using VBA to sort a large table whose row count can vary drastically. The current table I am looking at has 150,000 lines of data. There are 10 stages within the data table and each row has a stage number 1-10 in the first column. The number of rows...
  3. R

    VBA Code to sort tables and sum

    I have around 170 xml files and I wrote this code to import each file into a separate sheet. After the xml table is imported I have it remove duplicates, filter so only 6 rows are shown and then sum those 6 showing values. It works some of the time but is a little buggy. I haven't coded for...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top