Hello Paul,

hope you are great and thank you so much for all the coding help previously as well.

Absolutely smashing - does the job flawlessly.

This VBA code has also eliminated a lot of smaller issues I had regarding a number of tables I am working with. The small details can often make such a big difference, this is one of those things, by eliminating the need for more columns.
Initially I tried a number of other approaches such as adding columns, hiding the data, importing table from another document - yada yada yada - yikes it was enough for me to throw something at the screen.

Columns used in word documents are just not as intuitive as they are in excel and never play nice. With fewer columns, tables are easier to manage as I can simply make the font sizes smaller and then allow them to fill down vertically rather than with extra columns - which run off the page , and make it difficult to read or the the data disapears into oblivion, battling to and fro to get it back on screen.

This is an Awesome VBA Macro - I love it.

Anytime I need to find a table and insert some data I can do it now - knowing that I don't have to copy and paste same table into 10 other documents that needs updating, having to hunt down the table with words search and find, which will find everything you don't need - when you don't need it.

So this has saved me a ton of stress and work - such as having to hunt down tables, its also easier to insert data and placeholders now and leave it be, for looking at later.

Really really grateful for your ineffable generosity and help!


Need I say its really made my week!!

Have a Super Awesome week -

J


PS - I can use this template and adapt it for all sorts of other table magic, I have learned a lot from your coding and adapted macros to make mini me versions

I declare this Solved!

Thank you again!