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...

Some videos you may like

This Week's Hot Topics

Top