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
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