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