richiwatts
Board Regular
- Joined
- Aug 27, 2002
- Messages
- 131
I have an Excel file that looks somethng like below
Rubbish text = can be any text but we want to get rid of it
Message text = This is the actual word in the cell. We don't need this row but it is always before the row we need to keep.
Important text = can be any text but these are the only rows we want to keep. The only way to identify this row is when the row before it has the word "Message text"
Is it possible to do this with a macro?
Column A
Rubbish text
Rubbish text
Rubbish text
Message text
Important text
Rubbish text
Rubbish text
Rubbish text
Rubbish text
Rubbish text
Message text
Important text
Rubbish text = can be any text but we want to get rid of it
Message text = This is the actual word in the cell. We don't need this row but it is always before the row we need to keep.
Important text = can be any text but these are the only rows we want to keep. The only way to identify this row is when the row before it has the word "Message text"
Is it possible to do this with a macro?
Column A
Rubbish text
Rubbish text
Rubbish text
Message text
Important text
Rubbish text
Rubbish text
Rubbish text
Rubbish text
Rubbish text
Message text
Important text