T
tuk16664
Hi all
Not sure if this can be done at all, and hope someone here might be able to
help me first let me give you a run down of what my spreadsheet is.
Have a workbook with different sheets for every month in the year, which i
use to record the number of cases received. Keeps a record of each case
received and gives breakdowns of totals received for the month and year to
date etc.
What i need to do is using the running total on each sheet (i.e. total cases
received for the year to date) and have the spreadsheet calculate every fifth
case received (i.e. 1 in 5) that is received and either highlight the
specific row a different colour or put up a pop up message to say the case
needs to be audited.
If you need anymore information from me just let me know otherwise i hope
someone can help me out and thank you in advance for your time and help.
Matt
Not sure if this can be done at all, and hope someone here might be able to
help me first let me give you a run down of what my spreadsheet is.
Have a workbook with different sheets for every month in the year, which i
use to record the number of cases received. Keeps a record of each case
received and gives breakdowns of totals received for the month and year to
date etc.
What i need to do is using the running total on each sheet (i.e. total cases
received for the year to date) and have the spreadsheet calculate every fifth
case received (i.e. 1 in 5) that is received and either highlight the
specific row a different colour or put up a pop up message to say the case
needs to be audited.
If you need anymore information from me just let me know otherwise i hope
someone can help me out and thank you in advance for your time and help.
Matt