sort range

  1. D

    Auto Sorting an Area

    I have a group of cells (A2:C20) that constantly has new information. I always have to go into the data/range and sort the values so that they are in order by date. Since the content of this group of cells is always changing, it is kind of annoying to have to re-sort the list all the time. Is...
  2. J

    Copy two non-contiguous columns from one sheet to a single column in another sheet using VBA

    Let's say that I have a sheet("Members") with Columns A through Z The column and header names are: C- MemberID D- First Name E- MiddleName F- Last Name H- TelNo I want to copy from sheet(“Members”) to sheet(“LkupList”) Column(“C”) to column(“A”) as MemberID Column(“D”)plus a space plus...
  3. B

    Sort moves data to bottom of Sort Range???

    Excel 2010, windows7; After performing the sort shown below, why does the data end up at the BOTTOM of the sort range rather than at the top where it started and where it belongs? The first cell was in the upper left cell to begin with and after the sort it ends up in the bottom left cell...
  4. T

    sorting the autofiltered range

    Hi everyone, I would like to sort the autofiltered range without copying to a sheet using multiple criteria in ascending or descending order. I have done the autofiltering OK. The autofilter range can have 0 to n number of rows in it. When I try sorting on the filtered range I get various...

This Week's Hot Topics

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
Top