1 min readfrom 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.

submitted by /u/UsurpDz
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article