Hi Paul
thank you very much for looking at this for me, i have attached five files
word file - shows the place holders and field names from each of the original spreadsheet files
i have however used a vlookup formula to bring everything into one spreadsheet (combined file) in the hope that this would bring in the rent lines which need to go in the table on P2 and this is where i am stuck.
I will attach a PDF of how the finished letter should look
|