Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula - Anyone up for a challenge? | Excel Discussion (Misc queries) | |||
Excel 2002 Challenge | Excel Discussion (Misc queries) | |||
A challenge for an Excel Master... | Excel Discussion (Misc queries) | |||
A new excel challenge | Excel Programming | |||
A Challenge (Linking word and Excel) | Excel Programming |