Coping data between sheets based on conditions

**Phosphonothioic** · 02-23-2011, 10:25 AM

Here's the setup:

- Sheet 2 has two columns (A&B)
- Column A has the employee name
- Column B has was shift the employee works (Day, Twi, Mid, Sun)

I would like a macro to do the following:

In Sheet 1, I want a macro to populate column A with the names of all employees who work the Day sort based off the data in Sheet 2.

Any help would be appreciated. Thanks!

**watersev** · 02-23-2011, 10:42 AM

please attach sample workbook showing original data and result you need to obtain

**Phosphonothioic** · 02-23-2011, 11:00 AM

Originally Posted by watersev

please attach sample workbook showing original data and result you need to obtain

I've put together a quick and simple sample for you. Notice in sheet two some of the employees have a shift designated in column D.

If they work the Day sort, I want the macro to pull their names to sheet 1.

Thanks!