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