Hi Guys,

I have two worksheets, sheet 1 detailing all my current stock with part numbers and stock quantity and sheet2 containing a parts tracking sheet.

What I want to do is to input part numbers and quantities that I use into the part tracking sheet (sheet2) and have the quantities automatically removed from the current stock (sheet2).

Can anyone help with this?

Thanks

Dan