Please would it be possible for someone to help me.



What I'm trying to achieve is, when i click the complete mailmerge button, I'm want any rows in the table that contain a blank cell to delete the whole row and only show the tables for each person if it contains a data for them from the mailmerge.

In the attached document i have added a few extra rows to test to see if i can get any rows to delete, everything in red i want deleting when I complete the mailmerge

The maximum amount of comments and marks each person has is three, I've tried using a table with six rows, and i've also tried making three separate tables, however i can't make any macros do what i'm trying to achieve.

I really would appreciate it if someone could help me.

Many thanks

Attached Files

Remove rows containing blank cells.docx (13.3 KB, 19 views)