#1
|
|||
|
|||
Automatic Report Writer
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filename options when saving in Word 2013 - using report number at top of a report ? | swayzak | Word | 1 | 09-08-2017 08:54 AM |
Not all fields are exported to the Baseline Cost Report - Visual Report | Rowena | Project | 3 | 05-30-2016 04:24 PM |
Copy matching data from one report cell to another cell report | mbesspiata | Excel | 9 | 01-15-2015 01:49 PM |
Automation Process of Schedule Report Output and Report Check Score Card ! | ozman86 | Word VBA | 1 | 11-19-2014 11:52 PM |
Doc Paragraphs are Full Justified but not Printing to XPS Writer with Justification - | mmword | Word | 0 | 02-23-2011 04:08 AM |