VB Code Help.....

Need some help here with VB code... I have a *** named Adjust
Inventory and one named Supplies Inventory.

The Adjust Inventory has a form with two fields and a subtract
button.... one is a part ( Cell C6) and the other is quantity (Cell
E6) .

When the fields are filled out and the subtract button is clicked, it
will take the value in C6 and search column D in the Supplies
Inventory *** for that part.

Once the part is found, it will take the value in E6 on Adjust
Inventory *** and subtract that from the value in the supplies
inventory *** in column E for the found part.

Finally,after the adjustment has been made, the values filled in on
the Adjust Inventory *** will get cleared out so the next request
can be done.


Can someone at least help me get started at least? I can manipulate
the code but am having trouble starting it from scratch.






.