Hi, I'm not asking anyone to figure this out, but just wanting to know if it's possible so I can suggest it to someone! I would like to know if one has a table of items and amounts, with the amounts in columns by year, along with the percentage change (say, from 2020 to 2021), like so...
2019 2020 2021 Item 1 amount amount amount percentage change Item 2 amount amount amount percentage change Item 3 amount amount amount percentage change Item 4 amount amount amount percentage change
Also, one has some boilerplate MS word text that says something like the following: "The amount of Item 1 produced in 2021 increased by X% compared with that of 2020."
I would like Excel to determine what amounts increased by more than 10% and then somehow magically produce text that says "The amount of Item 1 produced in 2021 increased by X% compared with that of 2020; Item 2, XX%: and Item 3, XX%." It would have to know to insert the correct number of items, and the percentage increases should be in decreasing order in the text. If necessary, there could be boilerplate text in the Word document that could allow for 10 or more item increases and then the user could manually delete the extraneous blank items if only 6 increased by more than 10%, but that would be less helpful. Finally, if it would be easier for the text to be created in Excel and then transferred to Word, that would be fine also.
What I'm most interested in is the automated nature of this task and the resulting accuracy. Does it seem that this would be possible to do with a VBA script or is some other sort of software needed? Or is it even possible at all?
Sorry for the length of this question, and thanks in advance for advice!
Reply With Quote
