Hi All,

I have a list of employee names, beside each name is the shift they are working. i.e DS or NS (day shift or night shift)

What I want to do is have a code look in the list and pull every row that has DS in it, and paste it into another sheet, but not to leave any spaces between rows as they are in the employee list.

I hope this can be easily done. I'm ok with vba, getting better every day!

Thanks in advance for any replies