workinghard
New Member
- Joined
- Jul 9, 2012
- Messages
- 3
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:
1. The header rows can’t be labeled by a specific row number, as they are dynamic and will change as I update the spreadsheet.
2. I do NOT want the data to overwrite the data already existing under the respective header. I would like to insert a new row and copy the data (without leaving behind a blank row in its old location - so cut, not copied).
3. I would like the data to be inserted just below the header so it will not interfere with the sum calculations in the header rows. I don't think this is possible if it's inserted after the last updated data below the header.
Also, I imagine if it's inserted just below the header, the new row will take on the formatting and yellow background of the header row above it - any way for it NOT to take on the header formatting while executing the insertion?
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%
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.
Things to consider:
1. The header rows can’t be labeled by a specific row number, as they are dynamic and will change as I update the spreadsheet.
2. I do NOT want the data to overwrite the data already existing under the respective header. I would like to insert a new row and copy the data (without leaving behind a blank row in its old location - so cut, not copied).
3. I would like the data to be inserted just below the header so it will not interfere with the sum calculations in the header rows. I don't think this is possible if it's inserted after the last updated data below the header.
Also, I imagine if it's inserted just below the header, the new row will take on the formatting and yellow background of the header row above it - any way for it NOT to take on the header formatting while executing the insertion?
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%
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.