Help me sort my training material

[tjack_87]

Hi everyone.

part of my job is to deliver training to new starters and we have lots of different training we can offer. each training session needs various documents containing training material, to which i need to physically open and print for each new starter. it's sometime difficult to remember what needs to be printed off and where to find it, so i was wondering if you could help me with an idea i had?

I was thinking of creating something in Excel where i can select from a drop down, the name of the training and how many new starters i have, and then it automatically prints off the documents i will need for that session? I understand that there will need to be a sheet that lists what documents belong to which training, but was wondering how i would start the process and whether it would be difficult to do?

 

[Chelsea0270516]

First if you don't have any basis in VBA that will be a bit of a challenge to put together. I'd suggest making a drop down like you said & then having a folder for each variety of printing you would do. & hyperlinking to that folder as part of the drop down. (formating for that I am not sure on but your idea is great)

Example: for starter 1 you need doc 1, doc 2, doc 3 & doc 27. All are located in different files & need to stay there.
Make a new folder called Starter 1 Training Documents.
Make shortcuts to all your needed documents in this folder. (That way you aren't moving them or changing the organization and as they get updated you will have the updates) Then you just highlight all the documents & right click & select print.

Repeat as needed.



At first google this looks like a similar question Create a macro in Excel that will print a Word document without opening it. - Stack Overflow