Excel Challenge (or at least it is for me!)
 

I hope this makes sense.....

I have created a simple roster system (relatively).

Simply put, it looks something like this:

Name.................Mon (Date)..Tues (Date)...etc

Joe Blogs............A8..............C8............
Sam Ross...........B8..............A8............
Steven Smith.......off...............A12.........

Each shift has a unique code. The roster is for a 24/7 manufacturing
team, and involvse approx 12 staff per shift, working in varying
positions. The staff are seperated on the roster into 3 grps, based
on skill, and this dtermines to some extent where they work. This
also allows us to ensure we have an appropriate skill mix availabl
each & every shift.

Currently, I complete a diary each shift whereby I manually allocate
staff for the day

What we would like to do?

Either

1. Be able to print off each days list off working staff, by code
(shift) i.e. those working D8 and / or;
2. Have a shift form on another worksheet which will "auto-populate"
according to rules i.e. Group 1 only in certain positions etc. This
would be a case of the foreman arrives, enters the date and shift and
then a form autofills with whom is working and where - press print!

I love learning, and want to continue building on this, I have a basic
understanding (so far) of VBA.

Thanks in anticipation!