ok ive really gotten tired of manually finding each and every entry on my inventory list and checking the new inventory to make sure they match. What would be the easiest way to "link" these inventories together to have all the numbers match between them, and also update each if data is entered into one of them. On my older one all tools are on one sheet, and the new one is seperated into different sheets with each one labeled for a specific category of tool. the data got out of order from the older inventory when added to the new one so i cant just run through the list to match each number i have to go and find it for each one. thanks for any help
