Multitab Userform - Macros for each tab

[Kyhosa]

Hi,

First off, this is a lengthy request, but I have a MultiTab Userform, where each tab does something different. I have outlined what I am looking for below and the Excel Workbook is attached.

“New Employee” Userform Tab
Fill in the form, and when I hit enter, it will add a new row to the table on the “Test” tab. I had a macro started, but was having difficulties with the Start Date, when choosing the Type and when choosing the Shift. I also and am looking for the combobox for the for the TITLE, that it would pull the list of titles from column A on the "Training Matrix" spreadsheet. The macro is still in there but I didn't reformat it for this workbook.

“Training Update” Userform Tab
The Last Name drop down would pull the list of names from the Last Name column on the “Test” tab. It would then (if possible) generate a dropdown list of the First Names that are associated with that last name (if not then it can just pull a list of all first names). Then the Training drop-downs would generate a list from the first column on the “Training Matrix” tab. Once the form is filled out and you hit Enter, I want the date(s) be updated with the right person and the specified training. For instance if Joe Schmoe completed the Stop Tags training on 1/16/19, this would be updated in M3.

“Employee Termination” Userform Tab
Again the Last and First name boxes will be the same as on the “Training Update” Userformtab. Once the information is added in, it will cut the row, delete the blank row, and paste it onto a new row on the “Termination” tab, along with adding the termination date in the first column, which means everything will need to shift over one column.

“Title Change” Userform Tab
Last and First name drop downs same as previous 2 Userform tabs. The Title Change would grab the list of titles from the Training Matrix tab, first column. When you hit enter, it would update that employee’s title on the “Test” tab.

“Name Change” Userform Tab
Similar to the title Change, except the New Last and First name boxes would be manual entry.


Thank you in advance!