Hello,


I work in a group where everyday we have to generate reports (In word) for dozens of returned product, using specific text for each variable. I have written Hundreds of reports over the last year, and to save a substantial amount of time, I usually select a closely matching report as a template, using a Boolean search with specific key words. The thought had occurred to me that it may be possible using entry fields in Excel, to automatically generate a report in word, which would add a line of text based on my entry. For example if I Check a Check box, that a "Final Electrical test" was performed, text would be added stating "FET was performed". In addition, I would like Certain specific text from a text field to be added such as Voltage values, and Ideally I could also set it up for Additional options to appear based on my Text fields or check box selections. For Example if I enter a voltage value between 2.8V and 3 Volts (Lets say 2.9V), Options A, B and C will be available, and text stating the voltage was 2.9 volts will be added to the report, or if I enter a value between under 2.8V options D, E and F will become available. Does the idea for this project sound too elaborate? Any ideas where I could start? I have extracted the text from all of my reports over this past year, and sorted it. I just need to figure out, how to get excel to choose which text will automatically be added based on my response. If anyone is interested in assisting me, I can go into more specifics.
Thanks all,
Matt