Schedule and Inventory

my job is in production control and I had a schedule worksheet and inventory worksheet I need help in automatically updating my inventory worksheet with my schedule worksheet please help. I added an excel zip file for an example thanks in advance.

Here is your lookup formula to find the correct LU#. Put this in C2 and copy down

Please Login or Register  to view this content.

Regarding your question in your comment in the "LOB" sheet this will not be easy to base your filtering on color code. I think you better find another way of taging the status of each asset. Maybe add a new column for this. You can then use this column for filtering, and use conditional formating to get the background color you want to get the visual look right.

Hope this helps you a bit on the way

Thanks a lot for helping it will help me a lot