Inventory VBA code

I have 2 sheets for a simple inventory. The first sheet is where you enter transactions. Column F = SKU Number; Column H is transaction type in which I select ISS or REC (ISS is minus and REC is add); column J is the Location and column I is the Transaction Quantity. SKU Number may have multiple locations. I don’t know if another column is needed for the result of calculation. I want to retain transaction for several years, so column will grow up and as the transaction is added it will slow down the process when posting on the Masterfile.

The second sheet is the Masterfile in which the transaction will be posted every time there is a change in sheet 1 triggered by clicking the sheet 2. Heading of sheet 2 is:
SKU NUMBER – if the SKU number is not on the Masterfile, it will be automatically added when transaction is posted.
BIN LOCATION – location of each SKU
QTY ON HAND – is the result of calculation (QTY ON HAND minus ISS plus REC)

This is what’s in my mind and any suggestion is welcome. I am a newbie on Excel VBA, so I need help in creating a code for my project.

Thank you in advance and I hope to receive a response from the Excel guru’s soon.

Gemini528

Having seen more Excel takes on a stock system than I can shake a stick at, my only advice is this. Simply Don't

There are more stock systems out there on the internet than you can shake a stick at and simple ones are very cheap. Save yourself a huge headache (not to mention time) and spend a few quid a month. I guarantee that you will more than make your money back in time.