hi iam having 2 WORKsheets
one is stock
another is sales
In stock worksheet
iam having like this
Product Name stock-in-hand
p1 20
P3 30
P2 10
and in the sales sheet
iam going to entere the product name and qty
it has to deduct from stock sheet with corresponding stock-in-hand
but if the user delete or modify the sheet(sales) it has to reflect in the stock sheet.
PLS HELP ME, HOW SHOULD I DO IT..........
THANKS
one is stock
another is sales
In stock worksheet
iam having like this
Product Name stock-in-hand
p1 20
P3 30
P2 10
and in the sales sheet
iam going to entere the product name and qty
it has to deduct from stock sheet with corresponding stock-in-hand
but if the user delete or modify the sheet(sales) it has to reflect in the stock sheet.
PLS HELP ME, HOW SHOULD I DO IT..........
THANKS