Concatenated sorting

I have a daily report that I need to find and concatenate 3 cells to show the reason of the Criteria X, Y, and Z in the report table. I made a workbook with an example of my problem. I need to find in Sheet 1 column A1 today’s date (this table will have several days data), then from that point of the range move to the columns “X”, “Y”, “Z” and find what are the reasons for “X”, “Y”, and “Z” in this example I put Name, Initial, and Last name. I need to copy this data to Sheet 2 and insert the 3 cells values concatenate them in one cell, all the values (names) that match criteria X, Y and Z in to separate tables in the same sheet.. In the example will start in cell Sheet 2 cell B4 and insert all the full name of all the Name, Initial and Last name that were entered in the columns mark “X”, and do the same for “Y” and “Z”.

The key here is that the function use to find today date will replicate the data sorting every day and out put the same report daily.

I know that will be easy if the full name be entered in one cell at the data entry time, but I need them separate at that point.



Any input how to do this will be greatly appreciated.

Exec thanks for you reply .

I’m amaze how something that looks so complex can be so simple. I inserted another column and concanetaned all the colums I wanted togheter in the same sheet... filtered it..and Wow! no wounder you guys rule this Newsgroup.

Excelenator (or any of you thankful gurus), now how can now transfer this filtered criteria of “X”, “Y” and “Z” to another sheet only of the current day?

Thanks again for the replay.

P.S.


I want to extend my gratitude and admiration to every body in this Newsgroup, specially all those that take their time and talent to answer all our "want it to be like you guys" questions!

Excelenator!
broro183!
Bjornar!
mikerickson !
royUK!
rylo!
corinereyes!
BigBas !
Greg M!
solnajeff!
Leith Ross!
Steven_Daniel!
Alltmor!
daddylonglegs!
DominicB!
NBVC!
VBA Noob!


Thank you all....Moderator please let me thank them.