I have a portable version of 2003 so the help files don't work, please see attached files and it will make more sense. I would learn but I have been given a deadline for tomorrow and its taken 6 hours already.
You will see the excel spreadsheet is an Income & Expenditure Form pre-filled out as a test on how it will look.
The Word document is filled with characters like;
Applicant One Name
Applicant Two Name
The Macro would find C2 and C3 contents in this case and replace Applicant One and Applicant Two text in the document.
And so on for the rest, once I see a working example of the above I can complete it.
Bookmarks