Hi, I am trying to find a more effective method to maintain movement of my inventory. My current method is using separate workbooks for each location, when a product is removed from the location I strike through the row, give a location for where it went, and a ship date. When a product is added, I add a new row. I would like to consolidate this all into one workbook but I don't know what would be the most effective method of tracking these movements in one book would be.

I would like to be able to sort by type of movements (location to location, location to sale, purchase to location, etc...) and be able to track where inventory went too and came from (with my current setup I can only see where inventory went to).

Thanks for your help