Erika
Your post reads like you left something out in the middle. You mention
an "If" statement but you don't show any "If" statement. Post back and
describe what you have. Not what you want. Just what you have. Describe
it all as if you are talking to someone who knows nothing about your work,
your office, your company. Then describe what you want to look for. Then
describe what you want to happen when what you are looking for is found.
When you say you want to copy "field in column B", where do you want to
place it? What sheet? What column? What row? HTH Otto
"Erika" wrote in message
...
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!