MS Word VBA for text extraction

jake_barnes

Board Regular
Joined
Sep 29, 2005
Messages
55
I have a Word document that contains hundreds (or thousands) of similarly-formatted reports (about 30-40 lines of text with carriage returns), with lines that flag the start of each report and lines that are specifically flagged that I need to copy and paste at the bottom of the document, or into another document, whichever is easier.

What I need to do is activate a macro that looks for the first start flag ("START REPORT"), copies the line of text underneath it, then looks for rows flagged as "LAUNCH DATE" and "DETAILS", copies those, and then dumps all four rows of text at the bottom of the document. And then the code finds the next report (within the document) and repeats the process until it hits the end of the document.

Any thoughts would be greatly appreciated. Thanks!
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,224,945
Messages
6,181,934
Members
453,074
Latest member
JefersonKollet

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top