create a work schedule that automatically assigns shifts to employees

Hi,

I want to create a formula/schedule that automatically assigns a "person" to shift. Ive looked at NUMBERS work schedule template and although I think i'

ts fantastic its formatted by employee and not by the desired shift. Im sure if I changed the orientation of the caltulations in the template, there is a way to answer this question.

My work schedule defines the columns as WORK DAYS and not employees. All the employees are listed in a row for example as cashier, sales person, manager etc. I want to create some formula that automatically chooses a "name" from a data spreadsheet(EMPLOYEES) and assigns it to a summary spreadsheet(SCHEDULE), elliminating hours of painful scheduling every week

Below is a basic example

If there was a way for the calculation to know that It has to randomly choose any sales person defined by IE 'sales" (data spread sheet column b) and insert it into the summary sheet(schedule column C, E, G etc)

Is this possible? I can copy the formulas from the templat in numbers to compute the overtime etc if needed.

Thank you