I have a macro that I have created that utilizes a user form to populate a main table. A customer wants me to incorporate a list on the userform (pops up when excel spreadsheet is first initialized) where I look up if a person's name (in a separate name table that consists of one column) has been incorporated into the main table in the last five months (column H in main table has date and other column F in main table has a name chosen from the name table). If they have not had their name added to the list in the last five months, I want to return that list of names to a list box.
Example: Since Dan hasn't performed a task in the last 5 months, I want Dan's name to populate on the list box on my user form
Main Table (doesn't have all columns, just an example)
Name Table
Example: Since Dan hasn't performed a task in the last 5 months, I want Dan's name to populate on the list box on my user form
Main Table (doesn't have all columns, just an example)
Number | Job | Name | Date |
1 | A | Bob | 2/11/2021 |
2 | B | Steve | 2/01/2021 |
Name Table
Name |
Bob |
Dan |
Steve |