I have 2 Excel spreadsheets, one has a list of procedures with effective dates, the other has a list of personnell trained in the procedures with the date trained
Sheet 1 : 3 columns, code, description, effective date
Sheet 2: Employee no, name, code, description, date trained.
I am trying to construct a third sheet, which will combine data from sheets 1 & 2, to give me table highlighting when someone has not been trained on a procedure after the effective date. I am using Vlookup but this will only work for the first person in the database.
Any Ideas
Sheet 1 : 3 columns, code, description, effective date
Sheet 2: Employee no, name, code, description, date trained.
I am trying to construct a third sheet, which will combine data from sheets 1 & 2, to give me table highlighting when someone has not been trained on a procedure after the effective date. I am using Vlookup but this will only work for the first person in the database.
Any Ideas