I am trying to copy cell data from on worksheet to another based on the value
in a different column.

1 ws is a calendar - Each cell represents a day of month
1 ws is the month of January - Colums in this worksheet are "Day" and
"Applicant"
Column A = "Day" column is a drop down so user can select appropriate "day
of month"
Column B = "Applicant is a text column so user can enter the "applicant name"

I can get the "If" statement to work, but for only one cell at a time.
Because there could be multiple interviews on the same day I need to look at
the entire column A and copy the corresponding field in colum B

Any help would be great!