I have a post in the excel forum with attachments it can be found here

My question to the Word wizard's would be:

Is my request achievable? Each month will have a different result and therefore the word document will have different results for each month based on who is available for a duty on a specific day.

Is it possible in the Word table to select the name from column B for the respective day/date based on whether there is a confirmed duty assigned.
eg.
Tue 01 Jan 2013 has been assigned in cell G4.
Excel has searched G4:G24 and found no other conflicting entry, therefore it selects the user from B4 (based on the fact it has a value in it or, interior color index 4 set) and enters the name into the empty column Tue 01 Jan in the word document.

The same process applies to each day of the month.

Could anybody shed any light on the matter for me, or tell me it's not possible, or I need to look at Access perhaps to achieve this..

Thanks in advance for any assistance.