Shift Schedule Problem

**aakash00292** · 06-13-2012, 06:26 AM

I have an excel sheet for Shift Schedule of all the company workers in which the top row consists of the dates and the first column consists the name of the employees. And then correspondingly Shift names has been written - A, B, C or G.
Now I want to create 4 new separate sheets, each representing one shift and consisting people of that shift on different days.
I tried using IF( D3="A", C3, 0) ....this worked but left 0s in b/w the sheet and no continuation. And one has to manually delete the cells with os then.
So is there any other option?

**SDruley** · 06-13-2012, 07:12 AM

post example spreadsheet

**aakash00292** · 06-13-2012, 12:32 PM

Sample Sheet.xls

This is the sample file and would like to get names of all the employees in their assigned Shift Sheets on different dates.

**marc5354** · 06-13-2012, 02:25 PM

Hello Aakash,

In sample workbook main sheet contain name(s) and date(s).

In Sheet A(Shift), B(Shift), C(Shift) & (Shift), you want to represent employee names in each shift on particular date. Correct.

Marc