•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Creating forms/write-up using Excel data?
I searched through the subreddit and it seems the common approach for my situation is to use mail merge. I am wondering if there is a more elegant approach for long term use?
I have a data that has expenses, units produced, capital expenditures per region. I have to create a repetitive write-up per region using these data.
For example:
New York: We spent $60,000 to produce 5 units in the last 2 years. $300,000 in upgrades and retrofits to upgrade equipment.
My actual write up is a page per location and we have around 40+ location so I would like to automate this process.
[link] [comments]
Want to read more?
Check out the full article on the original site