Hello, sorry if this should be in one of the other forums but I'm not exactly too sure what I'm doing!



I am currently doing work experience in an office, and one of the tasks I have been given is to try and solve this. I will try to be as clear as possible.

We have a word document which is called an "Information Sheet" which is given to people starting work experience. This document contains a table with a number of empty fields (for example: Department, Name of supervisor, Hours of work) so I guess you could call it a Template.

The organisation is very large, and has several sites across the region. I have an Excel document with the details (like the ones needed in the Information Sheet) of all the departments which have work experience openings.

My supervisor would like a way to select a certain opening and have Word fill in the table with the relevant data from the Excel document.

I have been racking my brains for an hour now and playing around, and I'm starting to think that this is either not possible, or that it would require some kind of programming/macroing.

Would greatly appreciate a nod in the right direction (or even confirmation that this can't be done) from anyone who has the time. If I haven't explained it well enough please ask for clarification on anything.