I need to remove rows in a table where the Merge field is empty
In the attached Word document I have a table, where information is being pulled by merge fields from Excel.
When I hit Finish & Merge, I would like to have any rows (shaded in the example) removed but leave the formula cell (total amount) intact.
Some company's may have 1 in the SS section, and others will have 10. I have set the table to show 10, but if a company has less than that I would like the lines removed so that there is less white space when I send them a copy.
Please let me know if there is a macro I can add to my master template, that will allow the Finish & Merge to remove blank lines but leave the blank lines between the sections.
|