Loop Through Sheet and Delete Rows

Hi,

Our MRP system generates a report that is very poorly formatted. I am really after two key points of data that repeat themselves throughout the printout. I am looking for the item and the Economic Order Quantity. I would like to write a subroutine which looks through this list and deletes all lines except those that contain the key words "item" and "Economic Order Quantity". A snapshot of the report is as follows:

Item : 3010-0000-000-02 test
Planner : GK GK Disponent FS3
Order Policy : Anonymous
Order System : Planned
Order Method : Lot for Lot
JIT Item : No
Planned by SCS Planner : No
Order Quantity Multiple of : 1.0000
Minimum Order Quantity : 1.0000
Maximum Order Quantity : 999999.0000
Fixed Order Quantity : 1.0000
Economic Order Quantity : 1.0000
Re-Order Point : 0.0000
Maximum Inventory : 999999.0000
Service Level : 0
Safety Stock : 0.0000
Order Interval : 0
Safety Time : 2
First Allowed Order Date :
Order Costs : 0.00 [USD]
Seas. Pattern for Safety Stock:
Season Pattern for Demand :
Period : 1 Month
Update Inventory/Order Data : No


Item : 3010-0202-100-00 18750X1050 07-390/24
Planner : GK GK Disponent FS3
Order Policy : Anonymous
Order System : Planned
Order Method : Lot for Lot
JIT Item : No
Planned by SCS Planner : No
Order Quantity Multiple of : 1.0000
Minimum Order Quantity : 1.0000
Maximum Order Quantity : 999999.0000
Fixed Order Quantity : 1.0000
Economic Order Quantity : 3.0000
Re-Order Point : 0.0000
Maximum Inventory : 0.0000
Service Level : 0
Safety Stock : 0.0000
Order Interval : 0
Safety Time : 2
First Allowed Order Date :
Order Costs : 0.00 [USD]
Seas. Pattern for Safety Stock:
Season Pattern for Demand :
Period : 1 Month
Update Inventory/Order Data : No


The data is all contained in column "A"

Thanks in advance for any help you can provide.

Thanks, it worked great!