Autogenerate text based on cell values

Use a formula like:

="On " &TEXT(B1,"m/d/yyy") & " at " &TEXT(B2,"[hh]:mm") &" at " &B4 & ", employee was working as " &B3 &". While performing this task "&B5 & " happened. Employee sustained " &B9 &". First treatment was "& IF(B11="Yes", "provided.","declined.") & " Body part injured was " &B10 & ". Ambulance was " & IF(B13="no","NOT ") & "required."

Originally Posted by rohankumar03

... to create a macros in excel to create a text based on values from other cells.
For example:

On DATE and TIME at LOCATION, employee was working as JOBTITLE. While performing this task XYZ happened. Employee sustained INJURY. First treatment was PROVIDED/DECLINED. Body part injured was BODYPART. Ambulance WAS/NOT REQUIRED. etc.

1. Prepare a word document (e.g. Incident Report.doc) as shown in the attached image (or similar you come up with)
2. Change a bit your current xls file (Incident Description.xlsm) with descriptions in cells as shown in the attached image
3. 'doc' and 'xlsm' files should be in the same directory on disk
4. Paste the following code into the macro standard module and save 'Incident Description.xlsm' in xlsm format
5. Symbolic names ("FDTE", "FTME", "FLOC", etc.) contained:
a) in the macro code
and
b) in the body of the word document
must be the same and refer to the same description

Please Login or Register  to view this content.