MS Excel / VBA help thread

Workaround?

Sort the data by centre.
Then create a new bunch of columns that error check each cell in the data: Age blank?, DOB blank? Age error?
Every time they ID an error you insert the unique record number in that row.
So for your third row above checking for DOB blanks put in:
=if(D3=0,B3,"")
That would return the value 2.

So you have a bunch of blanks and some cells filled where there are errors and the data in those filled cells is the record number.

Then sort those new columns individually again so you get rid of the blanks and send that over to each centre.

You would get something like:

Dear Centre A - here are your errors:

Age blank
2
5
16
18

DOB blank
5
7
9

Age error
1
20
26

I am sure others will have better answers.
One thing though - the conditional formatting is a red herring. Ignore that.