So, I have data that comes in and some of it needs cut and placed a row after the bottom. I would like to automate the task.
My problems are:
1) how to find which rows to cut when the phrase may be embedded within other information in a cell (the key cell is always in the same column)... example: 1 KEY PHRASE c n, 2 KEY PHRASE n w, 0 KEY PHRASE x o, etc
2) how to paste it at the bottom below other data
3) how to get this to loop through until there are no more to remove... Sometimes there are 0, sometimes 1, sometimes more... I'm not sure how to make this work.
Thanks! I appreciate your help.
My problems are:
1) how to find which rows to cut when the phrase may be embedded within other information in a cell (the key cell is always in the same column)... example: 1 KEY PHRASE c n, 2 KEY PHRASE n w, 0 KEY PHRASE x o, etc
2) how to paste it at the bottom below other data
3) how to get this to loop through until there are no more to remove... Sometimes there are 0, sometimes 1, sometimes more... I'm not sure how to make this work.
Thanks! I appreciate your help.
