Good afternoon!
I'm making a payment calculator with excel and I need it to make a report. The thing is, I need excel to insert some information inside a relatively big text, and I don't know how I should work. Should I leave cells empty for those informations or should I use a macro to find specific places inside the text to insert those data.
I tried the first option, but the report doesn't look nice, it ends with some empty spaces that I want to avoid.
I'm basicaly looking for an answer on which of the two is the best way to proceed and some kind of sample code for the second option, if it's the case.
Thanks!