Copy Column name & row name if cell contains certain date [Closed]


I am trying to create a new worksheet based on the information in a previous worksheet. It is a training document and need it to pull out who needs what training.

Column A contains the name, Row 1 contains the training required. the cells are populated with the date the training expired. Some of these are blank.

I want for instance, if I choose "Jan", for the new worksheet to show each person and the training they require.

Can anyone assist?


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!