I have a spreadsheet which I fill out as and when, with set data.
It is one row per entry.
I then have a single page MS Word document with a table that I have to insert that data in to.
I've searched for, and tried various techniques of taking the spreadsheet data and sticking it in to the word doc, but it never seems to work or turn out quite right. Normally formatting craps itself, or it just doesn't seem to update with the data.
Is there a way for me to automatically generate this word document from the spreadsheet? The data fields never change, it's the same cells from spreadsheet to the same cells in the word table every time, just the actual data itself that differs.
Any help greatly appreciated!!