Results 1 to 6 of 6

Macro that will dynamically cut and insert entire rows after column cells are updated

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2012
    Location
    chicago
    MS-Off Ver
    Excel 2003
    Posts
    4

    Macro that will dynamically cut and insert entire rows after column cells are updated

    I am looking for a macro that, once a cell in the STAGE Column (Column “O”) is updated – for example, from 90% to 100% - will CUT the entire row of the cell that has been updated and INSERT it into the first row below the corresponding header row.

    Things to consider:

    * The header rows can’t be labeled by a specific row number, as they are dynamic and will change as I update the spreadsheet.

    There are 7 header rows with these corresponding values:

    1. Closed – 100%
    2. Pending Sale – 90%
    3. Decision Due – 75%
    4. Qualified Power Sponsor – 50%
    5. Qualified Sponsor – 25%
    6. Qualified Prospect – 10%
    7. Future Pipeline Prospects – 5%

    I have attached a model spreadsheet for you to see what I am trying to accomplish. What I am hoping to accomplish is any time I change a value in Column O – i.e. 5% to 10%, 10% to 75%, 90% to 25%, the row will automatically move underneath the stage that it is now in.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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