zachyfarms
New Member
- Joined
- Mar 25, 2019
- Messages
- 3
I am trying to streamline employee course completion records for my company. I have 20 plus sheets and each sheet is named with an individual employees name. Each sheet is identical with column A holding course titles and column b that is blank for not completed or it is filled with a date if the course was completed. I'm trying to build a search box or some search function that if I type a specific course name, it will check all the sheets for that course name. Then it will verify if there is a date in the B column for that course and return results listing all the sheets names of those who haven't taken the course. I would also like to create the same search but the opposite to search who all has completed a certain courses. Maybe since each sheet is identical i don't need to reference the course name and only search the associated date cell in column B to get the results.
I did try some count functions but they only return a count of the sheets not the names.
Again I am very new to excel and have only learned some basics like conditional formatting and table building. Below is what each sheet looks like and on a separate sheet labels totals I want to process all these searches.
Never mind, I couldn't even figure out how to paste picture of a worksheet.
Thank you in advance for any help.
[TABLE="width: 762"]
<colgroup><col><col span="5"></colgroup><tbody></tbody>[/TABLE]
I did try some count functions but they only return a count of the sheets not the names.
Again I am very new to excel and have only learned some basics like conditional formatting and table building. Below is what each sheet looks like and on a separate sheet labels totals I want to process all these searches.
Never mind, I couldn't even figure out how to paste picture of a worksheet.
Thank you in advance for any help.
[TABLE="width: 762"]
<colgroup><col><col span="5"></colgroup><tbody></tbody>[/TABLE]