Need Page Break on Change in Data in a Column

Welcome to the forum.

Try this and see if it does as you need - basic code, no error handling.
Row-1 is assumed to be a header. The code must go into a standard module.
1. Alt + F11 to open the VB Editor
2. Menu > Insert > Module (not class module)
3. Copy and paste code into code window
4. Adjust sheet and/or range references if needed
5. Alt + Q to close editor
6. Alt + F8 to open the Macro Dialog (be sure the target worksheet is active before running the macro

Please Login or Register  to view this content.

Or, just looping visible cells after advance filtering for unique values

Please Login or Register  to view this content.