Hi all, trying to work through a few things. We have a table that rolls on once a month and we have to print the corresponding word or pdf document assigned to that person. Is there a way with VBA to automate this? I can change the yellow squares so they have a Y or a fixed variable to indicate printing (rather than just having it yellow) and I can make the documents all PDF's or all Word Documents if it makes it easier.
| Field Leadership Schedule Template - Updated for March.xlsm | |||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | |||
| 5 | Place of refuge | Fundamentally Stable Parking | Self Rescuers | Fire Suppression - Mobile Equipment AFFF | Segregation - Mine Danger Sign | UG Fall of Ground - Seperation | GSI - Cablebolter | GSI - Shotcrete | Use & Maintenance of Fall Protection Equipment | Fall from Height - IT Hitch Point | Operator Behaviour - Underground LV | Haet Stress-Adequate Vent of Work Area | GSI - Ground Support Installation | GS - General servicing | AL - Hand Held Drilling / Bolting Operations | WFB - Working From Basket | TI - Tagging and Isolation | RO - Redpath Office Inspection | Underground Active Heading Standrds - Sumps | HV - Heavy Vehicle | LV - Light Vehicle | UW - U/G Workshop | WB - Work Baskets | Prohibited & Restricted Items | |||||
| 6 | x | x | x | x | x | x | x | x | x | x | |||||||||||||||||||
| 7 | |||||||||||||||||||||||||||||
| 8 | |||||||||||||||||||||||||||||
| 9 | |||||||||||||||||||||||||||||
| 10 | |||||||||||||||||||||||||||||
| 11 | |||||||||||||||||||||||||||||
| 12 | |||||||||||||||||||||||||||||
| 13 | |||||||||||||||||||||||||||||
| 14 | |||||||||||||||||||||||||||||
Mgt, Project Eng, S&T | |||||||||||||||||||||||||||||
