Andreas Hermle
asked on
Split big table several times on certain criterion
Dear Experts:
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
Regards, Andreas
Split-Table-On-Entry-in-column-A.docx
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
Regards, Andreas
Split-Table-On-Entry-in-column-A.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Andreas,
Thanks for the kind words. I'm happy it worked the way you wanted.
Paul
Thanks for the kind words. I'm happy it worked the way you wanted.
Paul
ASKER
great coding! Works like a charm, I wanted it exactly this way. Great!
Thank you very much for your professional job.
Regards, Andreas