G
Guest
Hi all
I need a little bit of help as my programming knowledge is shall we say a
little lacking!
On my spreadsheet it became necessary to flag one in every 5 specific deals,
i currently have the spreadsheet set up to count the said specific deals with
this formula, =COUNTIF(J32:J221,"Self Cert") then in the next cell the
following formula that displays a message in this cell
=IF((MOD((B6),4))=0,"Audit Next Case").
However i feel that some people are missing this little message so what i
would like to do it have a pop up box that they have to click ‘ok’ to get rid
of that will appear on every 5th self cert case.
If someone could give me, some code to do this and where to enter said code
i would be most grateful.
Thank you for your time
I need a little bit of help as my programming knowledge is shall we say a
little lacking!
On my spreadsheet it became necessary to flag one in every 5 specific deals,
i currently have the spreadsheet set up to count the said specific deals with
this formula, =COUNTIF(J32:J221,"Self Cert") then in the next cell the
following formula that displays a message in this cell
=IF((MOD((B6),4))=0,"Audit Next Case").
However i feel that some people are missing this little message so what i
would like to do it have a pop up box that they have to click ‘ok’ to get rid
of that will appear on every 5th self cert case.
If someone could give me, some code to do this and where to enter said code
i would be most grateful.
Thank you for your time