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