How can I populate a text document according to data in a spread sheet? Populated text would be relevant to, not the same as, the reference data.
e.g IF field = 'A' THEN populate doc with 'Paragraph A'. If data in spreadsheet field is ‘Red’ then populate text document with ‘Red is a popular colour’. I’d like to repeat this process to create a whole document according to a row/column of data.
(for context, the data is answers to a quiz and the document will be a report with paragraphs explaining each one of the answers they gave)
Best answer by ForYourITView original