Good Morning,
I am working with a workbook that has two sheets. One titled Quals and the other titled ATMS. It is one I use to track the qualifications of the 73 people in my department. I am trying to have Excel return the course description, the date/time of the training and the location.
On the Quals sheet, I have the employees names listed in Col "G". The info I want is contained on the ATMS sheet in columns "H", "I", "M", "N". I am trying to get Excel to give me the info, if it is there, in the corresponding row for a particular employee on the Quals sheet.
The ATMS sheet is constantly changing as new quals are obtained or lost so I have to be able to search the entire sheet and if it finds the employee's name in column "B", AND the Event Start (column "M") has at date/time entry(MM/DD/YYYY HR:MIN) then Excel will report the info in column "H"(ID, text), column "I"(TITLE), column "M"(EVENT START) AND column "N"(BLDG/FL/RM) info into column "O" on the "Quals" sheet.