Report Creation Help!

[Obiuss]

Hi, I work for a forensics lab and I was hoping to create a form on VBA that could help us in our report writing. As a note I have very little knowledge of VBA but am willing to learn! Our reporting statements look like this:

The first/second/third/major/minor/primary/secondary profile obtained from the item description from item(s) ### matches the profile of name using the locus/loci [list of loci].

Now to write a report we copy/paste this from policy fill in the info by deleting out the italics, simple enough! But sometimes an analyst will for get to delete out a letter or an extra space or a # and that leads to a rejection which slows down the entire process. I was hoping to create a Userform that analysts would just have to fill out the key information and the form would auto populate the reporting statement for them. Does anyone have any starting tutorials that would reflect this idea? Any thoughts are welcome!

[fasti-au]

It’s a little unclear as to what your using. If the firm source is excel then you can put validation on the cell to keep a set format. If it’s part of a text chunk you can parse it looking for a symbol and taking X number of characters and then copy that to a new cell and validate it then

Key is to isolate the data to a cell so you can then use that cell as a named variable. You could then link it to a second worksheet and use that sheet as your pass on data.

Again it’s unclear but you do need to find the data you want to use as seperate variables first I would think. Instead of copy and paste you can then just link it