#1
|
|||
|
|||
Auto Generate a MS Word table based on the amount of data
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto-populating table based on another table? | 0rion | Excel | 12 | 02-03-2023 09:24 AM |
Auto populate form (data from excel) in Word based on drop down list selection (data from excel) | wvlls | Word VBA | 1 | 03-22-2019 02:29 PM |
How to auto-populate data based on cell value | ag2686 | Excel | 2 | 06-13-2018 09:19 PM |
How to auto-generate whole Powerpoint presentations from a set of data? | olibot2000 | PowerPoint | 1 | 06-24-2017 09:01 PM |
Auto Generate Invoice Number Word 2013 | Jonah245 | Word VBA | 3 | 09-04-2014 05:24 PM |