I currently keep a record of all inventory on an excel sheet, when I sell something or uy some more I just go in to the correct line and adjust.

I would like to have a ticket that I fill in and the spreadsheet update itself from that.

Each item of stock has a four digit identifier, I would need to just input

Buy or Sell, Quantity, Price and (perhaps) Counterparty

How would I go about this, is it possible ?