sort a named range

  1. A

    Sorting a List based on values from another Sheet

    Hi !!! I started a while ago with a big project and not knowing a lot about VBA, I am still learning and looking up new ways to do things. I am currently trying to sort a list based on 9 different variables (1 of the variables is on sheet "Daily Schedule" and the other 8 are on "CO Times"). I...
  2. D

    Sorting Full Name Cells By Last Name

    Hi Team, I have a list of full names in a row that I need sorted by last name. I know I can separate the first and last names by using Text To Columns and the space as a separator, but I was wondering if there was a clever formula to spit only the last name out into a helper column...
  3. F

    Need help adding "Sort" function (with named range) into autofilter code

    Hello, I am having trouble adding the sort function into code that autofilters based off of criteria. I would like for this code to sort Greatest to Least based off of a specific column name ("Prior" or P in the code). I am also not sure if I should apply the filter criteria and then sort or...
  4. C

    Using VBA to Sort A Named Range

    Dear All, I am trying to create some VBA that will enable me to sort a number of Spreadsheets that come to me each month. The Spreadsheets are all in the same layout, however, the length of the Spreadsheets vary from only a couple of rows to several hundred rows. The problem is that the code...

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