Name | Week 1 | Week 2 | Week 3 |
Dave | y | ||
Phil | y | ||
Julie | y | ||
Barry | y | ||
Michael | y | ||
Karen | y | ||
Holli | y | ||
Nick | y | y | |
Kate | y |
<tbody>
</tbody>
Hi,
I have a master excel sheet like the one above. I'm trying to populate a series of other sheets with the names of people where there is a Y in the week column. For example, my Week 1 tab would look like this (and so on for week 2, week 3 etc.):
Name |
Dave |
Barry |
Holli |
<tbody>
</tbody>
All help much appreciated.