I got a big table spanning over a lot of pages.
I would like to achieve the following using a VBA macro:
The macro should perform the following tasks:
... to look for an entry in column A and ...
... whenever it hits an entry on Column A select that row and SPlIT the table
... since there are numerous enries in Column A of the table several splits are to be performed
... the table splittings automatically result in blank paragraphs.
... now the macro should insert page breaks (Ctrl + Enter) on these blank paragraphs.
Help is much appreciated. Thank you very much in advance.
I have attached a sample file for your convenience with before macro / after macro