I have a workbook with 3 worksheets, 1 main (total inventory), 2 sub
worksheets.
One of the sub worksheets tracks part #, store # and qty out, the other one
tracks part #, qty out, store # and tech id. I want to be able to insert
into the sub sheets and the main sheet have the items deducted.
Each day I physically enter new entries into the sub sheets, then re-enter
into the main sheet so the main sheet will show a true inventory.
Is there a way around all the duplicate entries?