I need help in this.
For example in sheet 1 there is a database where,
In column a there is name of items like apple, orange, pineapple, banana etc.
In colun b stock of that item is present. For example 10, 22, 33 etc
Now coming to sheet 2 (sale)
In a cell (a2) i will write banana and in cell (b2) i write a numeric value for example 5
There will be a button, when i will press the button i want the numerical value entered in b2 to get deducted from my sheet 1's banana stock.