Excel to generate reports in Word
I want to use Excel to generate reports in Word.
Column A contains text.
Column B contains Y or N.
If B1 contains a Y then put the contents of A1 into a new word document.
If B2 contains a Y then put the contents of B1 onto the next line of the
same word document.
If B3 contains a Y then put the contents of B3 onto the next line of the
same word document.
Obviously where column B contains an N, I don't want the contents of column
A on that row included.
It seems highly likely that someone has written some code to do this
already, so I'm asking for help here.
--
Regards,
David
|