I've searched this subject for a couple days now and I have seen this asked a few times but with their own request with specific technicalities like percentage of completion and such. Many answers include workflow or changing the cell in question to a formula which don't appear to be the answer here.
My interest in this is to modify a numerical value in a column by both manual input of that cell and with a function of another cell.
The column in question is my quantity of inventory where we can manually input how many of something we have. The trick that I'm trying to accomplish is to be able to manipulate the quantity remotely. For example, if I sell 3 widgets that include a number of parts in that column, I have other columns that tabulate this quantity (helper) and I need to subtract 3 from each of those items in inventory.
I'm aware on how to change cell values with functions like sumif and reference other sheets with vlookup but I have yet to find a method to manipulate another column's values, whether by performing the subtraction on the fly or to copy/move the value from one column to another.
Side note, I have an individual plan and the Business plan is entirely way too expensive. So I do not have access to copy and move features, which I'm not even sure are appropriate for this. If there is a single user Business account option were available for around $400 max, then I could see how I might be able to make better use but I may have to opt for some ERP system that costs about as much as the individual plan.
Enlighten me.
Have a fantastic week! I hope you can help.
William
