phoenix12345
New Member
- Joined
- Apr 27, 2022
- Messages
- 1
Hi everyone, I'm having trouble figuring this one out so any help is appreciated -
I am working on a workbook where the first tab has the employee names in column A, training topic in Row 1, and expiration dates for each training topic for each employee. On the second tab of the workbook, I have a training record for individual employees, training sorted by type, the name of the training topic, and the date that specific employee's training expires for each topic.
Essentially, what I want for the second tab, is if I select an employee's name from the dropdown list (data validation first tab column A), then it autofills the expiration dates by referencing the employee's name and the training topic from tab 1.
Tab 1 example -
Tab 2 example of what I would like it to do (can ignore the "Date" columns for now, I'll use a formula later) -
NAME is a drop-down data validation list from tab 1. Training topics are pre-filled in the template. I would like the expiration to autofill once it looks up the name from the drop-down list, and then references the training topic.
I am working on a workbook where the first tab has the employee names in column A, training topic in Row 1, and expiration dates for each training topic for each employee. On the second tab of the workbook, I have a training record for individual employees, training sorted by type, the name of the training topic, and the date that specific employee's training expires for each topic.
Essentially, what I want for the second tab, is if I select an employee's name from the dropdown list (data validation first tab column A), then it autofills the expiration dates by referencing the employee's name and the training topic from tab 1.
Tab 1 example -
Tab 2 example of what I would like it to do (can ignore the "Date" columns for now, I'll use a formula later) -
NAME is a drop-down data validation list from tab 1. Training topics are pre-filled in the template. I would like the expiration to autofill once it looks up the name from the drop-down list, and then references the training topic.