Excel VBA help -- 4

Job ID: 36007684

Budget: $8 – $15 USD

Please mention your fixed price in your proposal.

1. To Copy client names from Raw Data (Col A) and paste on Report 1 (Col A) without duplicates and sorted alphabetically.

2. On Report 2: Count cells from Col A of Report 1 based upon cell colors (Currently the formula is based upon conditions)

File: https://drive.google.com/drive/folders/17XxyYnX7Rjsy4RXyzAqXCjHu6XE0GkrG?usp=sharing