Thanks so much, CatDaddy!! You're awesome!!!
Only two more questions:
1. what should I do if I need to change the task names? For example, I changed them to Jan, Feb, March, April, May, etc and wanted to get the results by entering the names.
After I updated that form, I tried to change the code to
curTask = "Task " & InputBox("Task: ", , "Jan")
But it doesn't work well.
2. The other question is: how to be back to the whole table after the individual task searching is done?
Thanks so much again!!!!