I am having a few problems with a stock sheet I have created and was wondering if there was a way to simplify the huge number of transactions.

I am trying to keep a log of stock and need to book parts in & out of stock - thus giving a live stock figure.

So far I am logging 'goods in' into the sheet in columns F to K (my actual sheet is much larger, and involves scrolling along lots of columns to enter fresh info) and 'goods out' in columns N to S. A simple formula then works out the live stock figure in C:6

What I am hoping for is to enter each transaction within just 1 cell (A:6 Goods In & B:6 Goods Out) for the sheet to automatically log the date and qty of each transaction and then turn into a blank cell again waiting for the next transaction to take place. Sample11.xlsx

Is something like this possible or just an easier way of doing it?