This is the case, the parent table is inventory report, but I want to add an inventory of early warning function


1. This day inventory through the button of the trigger calculated, want to add a judgment function: (data) if the value is less than t column v column after the value of the corresponding warning "goods deficiencies" bounced, bounced only hint,
2 this day inventory through the button of the trigger calculated, want to add a "safety stock alert" button, do is: with the button after the trigger, to do judgment, if the value is less than t column v column corresponding value, then bounced warning "goods deficiencies," bounced only hint,
The above two functions to achieve a line


This master table is made of others, I also can't VBA this, so want to please help me to achieve it, thank you!!!!! Thank you very much!! Thank you very much!!

CodePudding user response:

 'to determine whether a V column value is greater than T column peer value 
Sub aaa 
Dim columnV, columnT 
V65536 columnV=range (" "). The end (xlup). Row 
T65536 columnT=range (" "). The end (xlup). Row 

For I=1 to columnV 'from which line it ourselves good 
Rnage (" V "& amp; I). The Activate 
If ActiveCell. Text & gt; Range (" T "& amp; I). The text then 
Msgbox I & amp; "Line item deficiencies" 
End sub 
End the if 
ActiveCell. Offset (1, 0). Activate 
Next I 
End sub 

1. Hand knock untested
2. Based on V and T column peer value, on the basis of comparison, such as V1 and T1, V100 and T100 than this