renumber

  1. W

    Auto renumber a queue

    Hi all, I have a list of items with a priority order with 1 being the highest priority. Sometimes, the priority will change and 1 will become 3. Is there a way to auto renumber the cells so that when a priority changes (for example: #1 becomes #3 ), the list will automatically shift and...
  2. T

    How to renumber with merged cells?

    Hi all, I have a database, where in column "B" of one of the worksheets some cells are merged (by 2, 3 or more) and some are not. I want to number them in order that every single or "group-of-merged-cells" cell will have just one number. For example, 3rd + 4th are merged, 5th is single and...
  3. T

    How to renumber with merged cells?

    Hi all, I have a database, where in column "B" of one of the worksheets some cells are merged (by 2, 3 or more) and some are not. I want to number them in order that every single or "group-of-merged-cells" cell will have just one number. For example, 3rd + 4th are merged, 5th is single and...
  4. tectonicseer

    Macro to add to or subtract from identified row numbers in multiple macros

    I have a spreadsheet that, when prompted by a list box, will hide or unhide rows in specified groupings. I will need to add and delete a few more rows throughout this list and by doing so will make the VBA script (sample below) non-functional (by "pointing" at the wrong rows). This script is...
  5. G

    Replace numeric values in a cell range by ascending order

    Hi Geek, My requirement is to renumber the values in a cell range. For example: If column e has 4 values of different numbers.. Column E: HT_53 HT_51 HT_07 HT_34 i want them to be renumber by ascending order. like below output is HT_01 HT_02 HT_03 HT_04 Could you please help out ... Many...
  6. M

    Change sheet's codename via code

    Hi <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have a workbook that has basic several worksheets but when I run a macro-report I am creating several dozen worksheet for each business unit. I delete these worksheets every time in order to create new...

Watch MrExcel Video

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