Mark has attended:
Excel Advanced course
Looping Macros
How can I insert a page break above a specific cell everytime I find a piece of text in a range of cells if my worksheet is a few hundred rows long?
RE: Looping Macros
Hi Mark
Thanks for getting in touch. You can only really do this in a macro with a little knowledge of the VBA language behind the scenes.
To try and make a life a little easier without programming, I would record performing a Find action (CTRL F) and Inserting a page break. Assign this macro to a shortcut key and you can press this over and over to insert your breaks.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector