abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,429
- Office Version
- 2019
- 2010
- Platform
- Windows
hello
i search way to sum the values in the lastrow is empty if is the sum = 1000 then sum and show in the lastrow is empty it be like this
col a14 = total and b14=1000 but if the summing value >or < than 1000 then show message you can't summing and exit sub if is possible the code into worksheet change event is better
thanks
i search way to sum the values in the lastrow is empty if is the sum = 1000 then sum and show in the lastrow is empty it be like this
col a14 = total and b14=1000 but if the summing value >or < than 1000 then show message you can't summing and exit sub if is possible the code into worksheet change event is better
report.xlsm | ||||
---|---|---|---|---|
A | B | |||
1 | CODE | QUANTITY | ||
2 | AA | 100 | ||
3 | AA1 | 101 | ||
4 | AA1 | 101 | ||
5 | AA2 | 102 | ||
6 | BB1 | 100 | ||
7 | BB1 | 100 | ||
8 | BB2 | 101 | ||
9 | BB3 | 102 | ||
10 | CC | 20 | ||
11 | CC | 20 | ||
12 | CC1 | 30 | ||
13 | CC2 | 50 | ||
sheet1 |
thanks