Good morning.
I have a table that has ten columns with values imported from other sheets into the cells.
I want to ultimately be able to copy tables into word for a report. The issue comes from every time I do the report I have a different number of products in the ten column table. I would like to be able to split the table into two tables with a maximum of five columns equally divided into the two tables. If there are less than four products I would like one table. If there are more than four products I would like the main table split into two tables with an equal number of columns.
The number of columns would be determined by the name cell being occupied. If it is empty then the remaining columns are not included in the resulting tables.
Then I want to be able to copy the results into word.
I have uploaded images of the tables as examples. Is there an easy way to do this with a macro?
Full Table
Less than four columns
More than four columns
I have a table that has ten columns with values imported from other sheets into the cells.
I want to ultimately be able to copy tables into word for a report. The issue comes from every time I do the report I have a different number of products in the ten column table. I would like to be able to split the table into two tables with a maximum of five columns equally divided into the two tables. If there are less than four products I would like one table. If there are more than four products I would like the main table split into two tables with an equal number of columns.
The number of columns would be determined by the name cell being occupied. If it is empty then the remaining columns are not included in the resulting tables.
Then I want to be able to copy the results into word.
I have uploaded images of the tables as examples. Is there an easy way to do this with a macro?
Full Table
Less than four columns
More than four columns
