If number is missing in a sequence, highlight and show number

Good day

I hope you guys will be able to help me.
I have 31 different worksheets numbered 1 - 31 (Days of the month) used for cashups. In Cell "H2" of each worksheet is a where i type in cashup numbers. Some days we are closed so there would be no numbers entered. all those numbers are then shown in a statement form in a list.

What i would like to know if possible, is if cashup numbers 351,352,353,355 are entered, it must highlight that cashup number 354 is missing. I tried using formula in the statement sheet but the problem is that list reads from Sheet01 etc and are filled with =+'01'!$H$2 which does not see the number it is refered to. So i need it to be able to pick up the sequence ist from "01" through to "31" ignoring any blank or "0" filled cells in "H2"

Please see attached file if it helps.

Thanks in advance

.
https://www.extendoffice.com/documen...-sequence.html

Hi Sintek

I would like the missing number(s) placed in the Statement Sheet cell D42. So if it does pick up a missing number, D42 would be either Bold Text and/or colour of cell changed to RED for example

Thanks for your assistance

Hi Logit

How do i do it across 31 worksheets and also leave out blank or zero'd cells?

Thanks

Hi pkool,
maybe UDF (see formula in D42 on 'Statement' sheet)

Please Login or Register  to view this content.

Hi Nilem

Thanks for this, really appreciate it. Thank to all of you that tried assisting. Enjoy the rest of your day!!