hello friends,
please help, my boss want me to make a reminder due to expiry date of our license.
the alert must be based on (the expiry date - 10), and the pop up will display the No.License.
the expiry date is in column I
No.License is in column F
<colgroup><col width="27"><col width="47"><col width="154"><col width="258"><col width="64"><col width="231"><col width="73"><col width="101"><col width="72"><col width="71"><col width="90"><col width="73"><col width="287"><col width="86"></colgroup><tbody>
[TD="class: xl113, width: 27"]NO
[/TD]
[TD="class: xl114, width: 47"]SECTION[/TD]
[TD="class: xl114, width: 154"] INDEX
[/TD]
[TD="class: xl115, width: 258"]NAME[/TD]
[TD="class: xl116, width: 64"]ISSUER
[/TD]
[TD="class: xl115, width: 231"]NO. LICENSE
[/TD]
[TD="class: xl117, width: 73"]I/L DATE[/TD]
[TD="class: xl115, width: 101"]QUOTA[/TD]
[TD="class: xl115, width: 72"]EXPIRES[/TD]
[TD="class: xl118, width: 71"]NOTIFY
[/TD]
[TD="class: xl118, width: 90"]SUBMISSION
[/TD]
[TD="class: xl119, width: 73"]Renewal L/T[/TD]
[TD="class: xl120, width: 287"]PROGRESS / REMARKS[/TD]
[TD="class: xl120, width: 86"]REMARKS[/TD]
</tbody>
Tks in advance
please help, my boss want me to make a reminder due to expiry date of our license.
the alert must be based on (the expiry date - 10), and the pop up will display the No.License.
the expiry date is in column I
No.License is in column F
<colgroup><col width="27"><col width="47"><col width="154"><col width="258"><col width="64"><col width="231"><col width="73"><col width="101"><col width="72"><col width="71"><col width="90"><col width="73"><col width="287"><col width="86"></colgroup><tbody>
[TD="class: xl113, width: 27"]NO
[/TD]
[TD="class: xl114, width: 47"]SECTION[/TD]
[TD="class: xl114, width: 154"] INDEX
[/TD]
[TD="class: xl115, width: 258"]NAME[/TD]
[TD="class: xl116, width: 64"]ISSUER
[/TD]
[TD="class: xl115, width: 231"]NO. LICENSE
[/TD]
[TD="class: xl117, width: 73"]I/L DATE[/TD]
[TD="class: xl115, width: 101"]QUOTA[/TD]
[TD="class: xl115, width: 72"]EXPIRES[/TD]
[TD="class: xl118, width: 71"]NOTIFY
[/TD]
[TD="class: xl118, width: 90"]SUBMISSION
[/TD]
[TD="class: xl119, width: 73"]Renewal L/T[/TD]
[TD="class: xl120, width: 287"]PROGRESS / REMARKS[/TD]
[TD="class: xl120, width: 86"]REMARKS[/TD]
</tbody>
Tks in advance