Making a training registry


So i am attempting to create a sheet where an employee would fill out a form and check into the training. This will go onto a sheet called "Hicksville Training Sign In" They fill out the form and it populates the rows.

Then I want the form to match two variables into the sheet called "EE Matrix" I want it to Match a column on both sheets called "Employee ID" and place the date of the training from "Hicksville Training Sign In" Into the cell under the column with the training title.

Take the date from picture 2 match it to the employee ID column in Picture 1 and fill the date in the column for picture 1 in the proper column matched in picture 2 to the training title column

Best Answers