HI:
I would apprecite help with the following:
On WorksheetA, I have a range A1:B10
A1 to A10 contains names of people
B1 to B10 contain AM or PM or blank (ie. those who are working AM or PM
shift or those who have off)

Based on the above I wanted to create another range on WorksheetB which
lists Name of all people working AM shift in range A1 to A10 (while
leaving out the name of all people who are not working either AM or PM
shift )
& list names of all people working PM shift in range B1 to B10 (while
leaving out the name of all people who are not working either AM or PM
shift )

TIA

Vinay