Find and Compare

Hi All,

This is my first post here and I am desperately looking for some help. I have attached a sample workbook that breaks down what I am trying to do.

i would like to run a macro that will allow me to press CAT A in the MAIN sheet which will then look into SYSTEM C sheet to see what falls into the CAT A. This will then select or copy all the IDS that fall under CAT.

This will then move onto the SYSTEM B sheet and find the IDS that were copied and get their COUNT values and then total these values up.

Finally, the total should then compare with the values within C5 (SYSTEM A Sheet) and a popup should then come up saying whether the values MATCH or No Match.

Hope that makes sense. If someone could please I would really appreciate it.

Thanks in advance.