migrating cell data
 

I have a Excel workbook that is used by my company to layout employee
schedules for a two week period. This is done via shift codes. For
example, the morning shifts could be a 2 or 2A or 2RR.

After the bi-monthly schedule is done we have to manually create a
DAILY assignment list from the master schedule for each of the 14 days
telling us where each employee will work. I am trying to use the
schedule created in Excel to automatically fill in daily assignment
sheets for each day.

Is there any way (without using visual basic) to have a formula look at
a at a value (code)in an employees master schedule and allow me to
assign that employees name to a cell in a daily assignment sheet.

I know it is complicated to explained, but basically can you look at a
cell in a worksheet, determine it's value and based on that, "copy" the
contents of another unrelated cell into another worksheet?