I have worksheet that has a list of my inventory. On a day to day basisi i
download a new file that has a complete list of inventory for my wholesaler.
What i am trying to do is take that data from my wholesaler find the products
that i am intrested in which will then automatically update any inventory
changes to the products qantity.
So to sumerize i need to

Find specific data from one file compare that to my exisiting file and
update one cells values depending on if there are changes.
Currently i am going line by line using the find fuction from one book to
find the data in the other book then looking to see if values have changed
and updating as needed.
This is very time consuming. Any help on this would be great.