Hi all

I'm trying to use VBA to provide validation for a recurring list I have of defined variables. I have a control table on a hidden sheet containing the potential items, however if an item is missing I want the macro to be able to say 'Item A' is missing (or 'Item B' is missing, and so on).

To complicate matters further, it can sometimes be one item or the other present - For example:

Always 'Item A'
Always 'Item B'
Always 'Item C' OR 'Item CC'
Always 'Item D'
Always 'Item E'
Always 'Item F' OR 'Item FF'

Anyway, I'm almost tearing my hair out here trying to figure out how to go about this.

Has anyone encountered such a problem or has any ideas?