I need a Google Sheets Expert

Job ID: 36604696

Budget: $10 – $30 AUD

I've created an inventory on Google Sheets. I need a way for a stocktake entry for a product to over write the stock on hand amount automatically. Currently stock on hand is calculated by subtracting all the "In" entries from the "Out" entries.