Report - how many new complaints came in that month

On worksheet 1 I have a table of logged customer calls. Each complaint has it’s own line item and it’s own unique number assigned. There are a series of dates for each line item listing when the complaint was entered, when it was completed by the assigned employee. Some complaints are listed as just verbal complaints, while others are listed as monetary complaints (customer looking for reimbursement on the product). Every month I generate a report by hand-counting and manually entering how many new complaints came in that month. Then I list how many of those complaints were verbal and how many were monetary. Then I list, if verbal, how many were completed within 3 weeks of submission, and if monetary, how many were completed within 2 weeks of submission.

I KNOW there has to be a formula out there somewhere that will look in the date submitted column to find the current month/year, then look in the “complaint type” column to determine whether the complaint was verbal or monetary, then compare the submission date against the completion date and return a count of how many were completed in the 2 week or 3 week timeframe (based on complaint type).

I’ve attached a sample spreadsheet. Could someone please help me out? This is my first major project attempt and I am still learning VBA. I know I’m a quick learner, but I’ve searched and searched for an answer similar to what I need for this one and I feel like I’m getting nowhere.

Thank you in advance!
Jessa

You've got some ambiguities in your description....but, I'll take a shot that I think will get you close.

Please Login or Register  to view this content.

Is that something you can work with?
Post back if you have more questions.

I'm glad I could help......and I applaud your enthusiasm!