1. Yes I have a list with Part # and quanity required for truck.
Column A is part # and column B is Quanity.

2. Yes I export my inventory with part # and quanity , into a text
file using a ";" to delimit the fields.

3. Yes, I import the inventory into Excel and set it up the same way
as the truck inventory. Using Column A as part # amd column B as
quanity.

4. Yes , I want to eliminate any part # and quanity that are not in
the truck inventory. If it is possible If i have something I want in
the truck that I dont have in inventory I would not like this deleted
from the truck inventory but could live with it if neccessary.

The part #s are unique as no part #s repeat. They use the same part #
if they are in the truck, warehouse etc.

I call the truck inventory file, "truckinv.xls" and full inventory
"compinv.xls"
Excel version 2000 9.0.3821 SR-1

Thanks Again