musicninja
New Member
- Joined
- Jul 26, 2016
- Messages
- 8
I am working for a company doing inspections, and I want to make a form letter such that it will populate a line iff a particular inspection was done. I have mostly done check boxes for stating which inspections were done. From this, I'd like to create a form that briefly tells what was done in letter format, as well as including other information like names and such. If at all possible, I'd like to keep this text in excel, as we already have a form for our (currently hand-typed) reports.
For example:
Technician arrived on site and met with (site contact). Technician performed the following inspections: (Scratching), (Sniffing). A set of (5) (Stickers) and (3) (Glue Sticks) will be brought back to the lab for further testing.
So you can see what kind of information I need to pull from the excel cells/checkboxes, but I don't want the sentence about bringing things back to the lab if no items were taken that day.
Any help is greatly appreciated.
For example:
Technician arrived on site and met with (site contact). Technician performed the following inspections: (Scratching), (Sniffing). A set of (5) (Stickers) and (3) (Glue Sticks) will be brought back to the lab for further testing.
So you can see what kind of information I need to pull from the excel cells/checkboxes, but I don't want the sentence about bringing things back to the lab if no items were taken that day.
Any help is greatly appreciated.
