Excel inventory vs production

[hullc]

I am working with an Excel document that contains a rolling record of the years production from a machine, and I am trying to add an inventory tab to track excess parts that are created.  I am having trouble getting information to work back and forth between the two sheets. The goal is to use the production sheet (sheet1) to constantly update the inventory of select parts (sheet2).  I have achieved the ability to highlight part numbers on sheet1 that are on sheet2, notifying the operator to check for inventory.  I want to use two quantity columns on sheet 1 to live update sheet2. (one column is quantity to make, which would reduce the inventory, and the other is quantity made, which would increase the inventory)  I've tried using a VBA macro, but I may not be able to use macros across the company network.

[#2]

@hullc 

You could help us help you by making a copy of this workbook available. Post it on OneDrive or GoogleDrive with a link pasted here that grants access to it.

In the absence of that, it's virtually impossible to give any practical suggestions, since so very much would depend on what your data elements are, how they're arrayed on the two sheets, and so forth. And, to anticipate a question, no, an image is not anywhere near as helpful as the actual workbook. If there's a lot of proprietary  or confidential information on it, create a facsimile without that actual data.