Stock update from received and booked columns on a (separate input sheet)

[Mark1961]

I have a stock sheet that I would like to update the stock on by entering goods received and booked out on another sheet. So I would enter receivals or parts booked out then click a button at the top of the respective column to update stock and clear the data entry column.

Can anyone help on this as I have very little VBA experience.
My workbook should be attached (Shows in managed Attachments) if not there please let me know.

Thanks in advance

Mark

[Mark1961]

Just as another note to this:
All I want to do is use a receival or booking out column to update stock then clear the input while keeping the updated stock.
I already have a button that clears the input column

[torachan]

As you are venturing into the world of VBA make the break from the tedium of maintaining on-sheet formula.
Attached is a simple stock inventory sheet done for a query on this forum some months ago.
The first form (Inventory) is used to load your initial items into the stock sheet, the other three forms buttons appear on changing sheet tabs and are self-explanatory.
To insert a new item first clear the form then add details and press new to add details to database - all calculations are done in the code NOT on the sheet.
When using tables do not manually extend them, they self-maintain and expand and contract with additions/deletions.
torachan.