Hi,
Attached is the excel spreadsheet I am working on. There is a Multi Page UserForm created. On the "Training Update" tab, there are multiple things I am trying to achieve. If there is a better way to structure the UserForm, I am open for suggestions. I want to pull all the names from the "Full Names" column (C), so it' easy to pick and choose. Then the "Training" dropdowns, I also want them to pull the row (1) of training titles from the "Training Matrix". Then when someone selects the name, training and date, then clicks "Enter", a Macro will look at row (for the name) and column (for the training title) on the "Test tab" and enter in the date, where those 2 intersect.
I want to be able to enter multiple training titles, in case someone completed more than 1, which is why I have 2 drop downs. In my actual spreadsheet I will have more.
Thank you in advance!
Bookmarks