Excel macro developer

Job ID: 35983017

Budget: $250 – $750 USD

Would like to create a macro or anything else that would achieve the goal.

I have an excel report with data, I would like a macro or some other “software” to create a report from those inputs on a reoccurring basis

Law firm has many clients. We want to be able to run a report to determine how many clients are active, inactive for 90 days, inactive for 180 days, etc. based on when their cases closed with our firm or if they have an open case.

Further, program should be able to label each client with a color based on how many days the client has been inactive and then as the clients inactivity ages the color should automatically change