How do you use Excel to create memorandums?

2019-06-15T13:14:59-04:00

I'm pretty good with Excel, but creating macros (and pivot tables) are outside my forte. Has anyone made an Excel sheet that creates a word document in memorandum format? If anyone has one, please let me know! I'm looking to create one.

Response by SFC Marc W. made Jun 15 at 2019 1:25 PM

2019-06-15T13:25:22-04:00

Better off using word. You can get a template easily and much easier to manipulate in a word processor.

Response by MAJ Private RallyPoint Member made Jun 15 at 2019 6:12 PM

2019-06-15T18:12:55-04:00

The answer is coding it in VBA, the programming language shared by all Microsoft products. The base code would be in excel which is the source of your data (I assume). I’d create a VBA module in excel that would generate a Microsoft word template for whatever you are doing and execute code to place values from your data into your Microsoft word document. Then I would just use a macros button in excel probably right on your data spreadsheet that you would just click on when you have finished inputting your data. The button just executes the coding module previously described, and boom, instant memo with the right names and info. Not sure what organization you are in, but if you have ORSAs near you, then can help you set that up. Most of us are quite familiar with VBA. Also if you have any computer science types around you, they should know VBA.

Response by CWO3 Private RallyPoint Member made Jun 21 at 2019 9:09 AM

2019-06-21T09:09:18-04:00

You can put links in cells to whatever you want. Create in Word and post a link to it in cell of spreadsheet. Spreadsheets are not user friendly for wordsmithing.

Response by MAJ Ken Landgren made Jun 24 at 2019 12:41 PM

2019-06-24T12:41:14-04:00

Designate the top cells as centered.
Add blank cells for spacing
The body of the memo should be Left aligned.
You got the drift?