Inventory count

[fasterthanyours]

Ok let me see if I can explain this one. :D

I've got these inventory numbers that I've been working with.

Last years Usage and this years usage combined per warehouse for each item.

Plus another sheet that has On-Hand counts per warehouse for each item.

What I'm trying to do is pull my usage count per item per warehouse and place it all on different sheets so that I can compare numbers and do a few different things.

On my data sheet I have the warehouse number, in my example, "TOT.", 0100, and 0101. In the next column is the item # and on the end is the total used for that item by that warehouse.

On my the individual warehouse sheets I have the warehouse number, and the item # and some other things.

What I need is someone to look for the warehouse name "TOT.", 0100, or 0101 and then find the Item # and get the total used from the total column. If it wasn't used or does exist then I need 0 to appear.

Anyone know how to do this or follow me?

See attached file.