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