Ok, this might get confusing and considering I have no training in this, this
ought to be good. I am doing an inventory workbook. Say I have 4 lipsticks
in stock and its Part number is 10-6161. Everytime I enter the Part Number
(10-6161) in a column on Sheet B, I want it to subtract from the number I
have in stock on Sheet A.

Site Layout:
Sheet A Cell A1 Part Number 10-6161 Cell D1 In Stock Number 4

Sheet B Column A Part Number 10-6161

Subtract Sheet B Column A from Sheet A Cell D1


I hope someone is able to help me. This is confusing.