Results 1 to 4 of 4

automatically re-number when not deleting rows

Threaded View

  1. #1
    Registered User
    Join Date
    01-28-2014
    Location
    Connecticut
    MS-Off Ver
    Excel 2013
    Posts
    7

    automatically re-number when not deleting rows

    Good day everyone!
    I have a list of jobs to do in 1 column. In column 2 is the priority of the job. As a job is finished I want to delete the priority next to it and have the priority numbers re-number themselves (2 becomes 1, 3 becomes 2, etc.). These jobs are ongoing, so at some point I would want to go back to the original #1 and call it priority 6, so deleting jobs altogether is not an option, thus taking out the (row-1) ideas.
    Any ideas on how I can set the priorities up to re number.

    The list is not in order vertically because the priorities are not always the same.

    Thanks for the help!
    Last edited by love for excel; 12-23-2014 at 05:04 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro for Typical scenario
    By toravietl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2014, 08:31 AM
  2. Replies: 2
    Last Post: 07-11-2013, 10:04 AM
  3. A typical two way lookup
    By learning_vba in forum Excel General
    Replies: 4
    Last Post: 02-16-2011, 11:42 AM
  4. Objects and their typical properties...
    By phuang1226 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-20-2006, 01:11 PM
  5. Typical excel interviewing questions
    By Interview in forum Excel General
    Replies: 3
    Last Post: 07-14-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1