You might also consider adding another column to your main inventory list and
put an indicator in that column for the items that are stocked on the trucks
- maybe a simple "T". Then you could use Data | Filter | Autofilter to
quickly show just the items in your main inventory list that are in that
group.

If you still want to do something with combining things into one book and
removing non-duplicate entries, that can be done fairly easily. Others may
post some ideas before I come back and see if Data Filtering seems an
acceptable solution to you or not.

"sheed3k" wrote:

Ill try to explain my problem as best I can. I run a swimming pool
service company with 4 trucks that need to have the same inventory
loaded at the beggining of the season. I have an excel file with part
# and quanity that I require. I also have another file with my
complete inventory. I stock a lot more parts then I want in each
truck. What I would like to do is create a list of how much inventory
I have in stock of ONLY the items needed to stock the trucks. It cuts
my list in half and helps it easier to order what I need. I thought
maybe I could combine the truck list and the inventory list and delete
non duplicates from the inventory list. If this makes sense any help
would be appreciated. Thanks
Scott