Auto Generate a MS Word table based on the amount of data

[fordmuntsinger]

I need to make a table in ms word that can change from 2 rows all the way up to 8 depending on how many values are in the one row in my excel workbook. I am using an if statement to bring up values or words in a different row so I can make the item being put into the table anything I want to, but right now it is just blank. I do not want to have to copy and paste VBA code into the module every time I make a new mail merge document that gets rid of all blank cells. I would rather do a bunch of work right now so my associates do not have to learn what the developer tab is haha.



Basically a table that will change in size (from 2 to 8) depending on the row being blank or not. Also there is a merged header as well as a header below that with 5 columns and a bottom "header". They all have 5 columns except the top row.

I can provide excel sheets and word documents just lmk.

I hope that made sense, but thanks for any help in advance.