Generae Report Based On Column Value

Thanks for your reply so i my assume that this is the final script for CCHI VAlid or Expired. I have one more request. Please check the below details.

Provider Types:-

1. When I select any of checkboxs i.e. Hospital and click generate networks button then script should copy complete row for that class from Column A till Column N in a newly create workbook with sheet named class records count as mentioned in sample file. But it should take only those records whose value is equals to “Hospitals” in Column C & it should omit others records. Second option based on CCHI Valid or expired.

As An Example: If I select checkbox for Hospital & CCHI Valid then the script should copy entire row from A to N with sheet name formatted as column C and records count. Hospitals sheet name will be Hospital (11) Check the sample given.

2. Serial numbers i.e. 1, 2, 3, etc… should be automatically in column A for all new sheets when I run the script.

Region:-
3. Same procedure should be done to when I select any of the regions.

5. Serial numbers i.e. 1, 2, 3, etc… should be automatically in column A for all new sheets when I run the script.

4. It should display message says” You did not select CCHI Valid or CCHI Expired” if I did not select either CCHI Valid or CCHI Expired