VBA to remove un-needed information

**Ada01** · 06-28-2010, 09:46 AM

I am going to try to explain this the best I can because I am out of ideas on making this work.

I get a report that comes out of an old banking system and it is compiled with some extra information that I always have to delete by hand - i do not want to do this any longer! Following are the steps that need to take place (i wish it was as simple as a loop) in order to get rid of the information.

Step 1. Delete everything from the first document line until "Header Text" (leaving the header text in tact)
Step 2. Delete everything from "Specific Wording" to next "Header Text" (leaving the header text in tact)
Step 3. Repeat step two
Step 4. Delete everything from "Specific Wording" to the very last line of the document.

The problem i am having is that I do not know how to delete using the "header" or "specific words". I think this is going to have to be the way it is done because the amount of other text in between each header and specific words varies considerably. I got the whole "find text" vba thing going, i just need to fill in the blanks.

Thanks

**royUK** · 06-28-2010, 10:35 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**Ada01** · 06-28-2010, 11:27 AM

.................

**Ada01** · 06-28-2010, 11:29 AM

i have hidden and protected the proprietary information, but here is the document i am working with. Yellow highlights are the "headers" and the red is the "Specific text".