Searching worksheet and exporting name to other sheet

[OshawaChris]

Here is the basics for the formula I need (this pertains to payroll and
attendance sheets)

My worksheet (sheet 1) looks like this.

A B

1 employee name 1 Day
2 employee name 2 Evening
3 employee name 3 Night


The function searches column B for a string (Day for dayshit etc).
If the search is true, then it takes the string from colomn A in the same
row (employees name), and exports the string to a cell in a different
worksheet "sheet 2".

Any help would be greatly appreciated.

 

[Don Guillett]

You can do this with formula, macros, or a simple
data>filter>autofilter>filter on day>copy rows to destination sheet. More
examples and before/after desires