Hello,

I am a novice Excel/VBA user. I am trying to create an Excel worksheet for my job and I am stuck on the last Command Button. I will attach pictures of what I am trying to do and my "non-functioning" code.

What I am trying to do is enter a key name in D7 and the quantity issued in F7. When the "update inventory" Command Button is clicked i would like the inventory to automatically be adjusted on the "Key Inventory" sheet.

Any help would be greatly appreciated!

issue.jpg
COMMAND BUTTON.jpg