Ensure mandatory fields inputted by the user

Hi folks,

The sample data with the vba code is attached.

I need on click of the button in the "Results" tab, I should get an error if all the mandatory fields (marked with *) are not inputted by A/B/C and get the notification like...all the mandatory fields are not inputted by A or B or C, if 2 will not input...it should be like...all the mandatory fields are not inputted by A and B. These mandatory fields are dynamic in nature.

Hope I am clear with the requirement. I am novice to macros, hence thought of reaching out to experts community.

Thanks in advance...
Abhi

The most direct way to force users to make valid entries is to use formulas to check for valid entries. If all entries are made and valid, such formulas return 0; otherwise, they return an error value. If such formula were in cell X99, often convenient to have another formula in Y99: =IF(COUNT(X99),"",X99). Then all other formulas which should return numbers would include +$X$99 at the end, and all formulas which should return text would include &$Y$99 at the end. That means all formulas would display errors unless all entries were made and valid.

Cleanest way is to use a UserForm as an interface to the sheet - all data handling can be checked before entry to the sheet.
Simplify the data storage to one sheet - if this involves data storage of many inquiries - unique identifier is needed and the format would be simpler in table form transposed to that shown.
torachan.

Perfect. Got you...Thanks