In the attached sheet("AuditIssues"), there is one button that says, "Analyze Data". Clicking it brings up the userform "Active Issues Analysis"; it has one combo box and 2 text values. I need help with following:
1) Combo box: In the choose period combo box, I want to be able to choose 4-types of date (issues that are 0 to 30 days old from today, 31 to 60 from today, 61 to 90, 91 to 120 from today and more than 121 days from today BASED ON COLUMN B AND the value "Active" from column H.
2) Text Box1: I want to count "Active" from column H based on the filtered data.
3) Text Box 2: Count no. of unique numbers from column A.
I need to make the range in column A, B and H to be dynamic, I don't know how to set the dynamic ranges in macro. Can some please help me? Thanks.