sorting table

  1. C

    Names ranges within a table not correct after sort

    How do I create names that will stick with my data even when I move it around? I have my data in a table, to make it easier to sort. It looks likes this: Project Value Timing Stage Confirmed(Y/N) Proj1 $100 3/15/11 Confirmed TRUE Proj2 $50 4/1/11...
  2. pedie

    Sorting whole table question. Please help.

    Hi Everyone, I have a table that varies by size but it starts from range A2:F12, sometimes A2:F11, A2:F10, A2:F24 etc It is not contant, can i have a macro that can select the whole table by default and then sort it by col b in sheet1, from highest to lowest??? If I just record normal macro...

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