Hello Guys,

Please i would require your assistance on an inventory stock management application i am creating using MS Eexcel and Access.

I would require a VBA code to update current stock level whenever sales is made.

An Example if i have

50 items of Pencils and 30 was sold how do i update my stock level immediately to reflect the balance of 20

I will appreciate a swift response either using MS access or excel