Forum Discussion
Formatting: merged cells vs word wrap in service report
Background: Over the years, we developed a spreadsheet in house for our estimating, invoicing and service reports, made up of multiple sheets within the spreadsheet. Fields are populated in subsequ...
You don't really give enough information for a truly meaningful reply. It sounds as if what you've developed over the years has, to use a cliche, "grown like topsy."
Whether that's fully accurate or not, it does seem as though you might want to start from scratch to rebuild. Along the way, you could look into building a process that uses Excel to store the basic data over the life of a given contract, and Word (via MailMerge) to produce the final printed documents you send to the customers. You could have coded phrases with the merge process itself producing more complete sentences in Word.