Copy cells to another sheet based on criteria

[shadyshawn]

I have a list of employee schedules in sheet "Schedules", I'm wondering if there is a code I can pop such data to the "January" sheet; basically showing who will be working on what day. Any help is greatly appreciated!

[RicktheBlade]

=IF(Schedules!B4="Mon",Schedules!A4,"") for cell D8 of "January". Just looks at B4 on the Schedule and returns the name if A4 equals "Mon". Will need to adapt slightly for each cell in the January sheet.

[shadyshawn]

Thanks, I don't think that serves the purpose tho

[RicktheBlade]

Depends on how exactly you want it to work, perhaps indexing will work

[shadyshawn]

what I'm trying to achieve is say, whoever show "In" on Sun, their names will be copied and pasted to the cells with the heading "Sun" in sheet "January" (as shown in the attached file). so far I can use the code to select the ones I need, just dont know how to paste specific cells per their headings.