Running macro only if linked cell are updated with values

Dear All,

I have an excel with macro to create an outlook mail when i double click on any cell in column1.

I have report names with information of categories included in the report. Report can include one category or more than one category as shown in example below.


Report Category
Microsoft xyz, chs
Macintosh abc

I have another sheet with category codes and their values. I want to run my macro form "FINAL" sheet only when values for all category code are updated. Is there any way to link cells. My problem is linking cell with multiple category codes to the cell having single category code. example as above, in microsoft report i have XYZ, CHS multiple category codes. I want to check in sheet "CATEGORY" if values for xyz and chs have both been updated. if any of the category code is missing with value i want macro to pop an message box as "category value not updated"

I have attached an example sheet for clear understanding.

Looking for your support.

Thanks,
Suraj

No Body knows answer for this post?